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 vote332 views1 answer
How to find unique key in sql
SQL
0 vote329 views1 answer
Replace sqlalchemy
SQL
1 vote363 views1 answer
Select users with same username
SQL
0 vote338 views1 answer
Mysql function variable
SQL
12 votes353 views4 answers
Import mysql database command line linux
SQL
6 votes372 views2 answers
Sql sequence
SQL
1 vote348 views2 answers
List tables sqlalchemy
SQL
0 vote335 views1 answer
Uuid sqlalcomany
SQL
0 vote377 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote337 views1 answer
Find most frequent value in SQL column
SQL