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

1 vote222 views1 answer
SQL Integer devision
SQL
7 votes194 views2 answers
Create index mysql
SQL
0 vote193 views1 answer
IIF
SQL
0 vote206 views1 answer
Python mysql executemany
SQL
1 vote216 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote194 views1 answer
Sql server cannot create database diagram
SQL
0 vote210 views1 answer
Oracle show running job
SQL
0 vote216 views1 answer
Add a new column into table
SQL
27 votes211 views5 answers
Add column in table
SQL
0 vote206 views1 answer
Mysql equivalent decode oracle
SQL