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 vote253 views1 answer
PGSQL dynamic table name
SQL
0 vote232 views1 answer
Select last 2 characters sql
SQL
1 vote250 views2 answers
Sql insert timestamp
SQL
0 vote260 views1 answer
Sql express database size limit
SQL
3 votes245 views1 answer
Stpop start psql server
SQL
2 votes237 views1 answer
Apex execute batch job
SQL
0 vote251 views2 answers
Connect to mysql server mac terminal
SQL
1 vote241 views1 answer
Mysql list bigger table
SQL
1 vote250 views1 answer
Sql select max value from multiple rows
SQL
2 votes299 views3 answers
Mysql unix timestamp to date
SQL