Get rows count of the tables – Microsoft SQL Server

[sql]
CREATE TABLE #counts
(
table_name varchar(255),
row_count int
)
EXEC sp_MSForEachTable @command1=’INSERT #counts (table_name, row_count) SELECT ”?”, COUNT(*) FROM ?’
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC
DROP TABLE #counts
[/sql]


Posted

in

by

Comments

Leave a Reply

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