How to count each record in each table in a SQL Server 2005 Database?
Posted
by Heather
on Stack Overflow
See other posts from Stack Overflow
or by Heather
Published on 2010-03-29T20:29:25Z
Indexed on
2010/03/29
20:33 UTC
Read the original article
Hit count: 166
sql-server
|sql-server-2005
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.
© Stack Overflow or respective owner