Sql server count all tables rows

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

Similar codes

0 vote339 views1 answer
Join in update query in mysql
SQL
0 vote331 views1 answer
Get last date join sql
SQL
0 vote368 views1 answer
Check database restore status sql script
SQL
3 votes355 views1 answer
Oracle list dates without weekends
SQL
0 vote342 views2 answers
Tsql row number
SQL
2 votes353 views2 answers
How to create an empty table from an existing table
SQL
0 vote353 views1 answer
Faire une recherche par liste de mot clé sql
SQL
6 votes364 views4 answers
Mysql update set
SQL
0 vote349 views1 answer
Mysql exception output
SQL
9 votes352 views6 answers
Replace sql
SQL