In a previous post I talked about how to find highly populated tables in a database. I’m going to expand on that in this post to show how to catalog a database into data-holding tables and supporting details tables. Continue reading “TSQL Query to List Tables in a Database with Row Counts”
When you are working with an unfamiliar database, such as a third-party SQL Server database, you want to find out which tables actually store the important data. If there is no clean database diagram, then the best option is to write a T-SQL query in SQL Server Management Studio (SSMS).
If you are interested in this topic, then I’d suggest also reading my article on batch searching your SQL Server database to find out in which tables the information is being stored.