Quickly Investigating What's in the Tables of SQL Server Databases
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Wed, 20 Aug 2014 06:00:00 UT
Indexed on
2014/08/21
22:24 UTC
Read the original article
Hit count: 231
From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.
![]() | Want faster, smaller backups you can rely on? Use SQL Backup Pro for up to 95% compression, faster file transfer and integrated DBCC CHECKDB. Download a free trial now. |
© SQL Server Central or respective owner