How to count each record in each table in a SQL Server 2005 Database?
- by Heather
I need to know how many records are in each table in a particular database. I don't care what is in the record, they will all need to be counted.
I already know how to do this for a single table as SELECT Count(1) FROM [my_table_name], but this gets a little redundant for 200+ tables.