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: 188

Filed under:

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.

SQL Backup Pro 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