SQL: Count number of records in each table within a database

The Transact-SQL script below 1 (written for SQL Server 2000, but also works with 2005), returns a list of tables and a count of the number of records within each table.

  1. Please ensure you test any script taken from my website on a test/development machine, before running on a production server.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

CJayMead's SQL Server, Endeca, MS Office Help © 2018