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 vote254 views1 answer
Osm2pgsql mac
SQL
1 vote195 views1 answer
Mysql show data from table
SQL
0 vote221 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote193 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote181 views1 answer
Azure sql server check foreign key
SQL
2 votes195 views5 answers
SQL trigger
SQL
0 vote217 views1 answer
Sql server delete records with specific date
SQL
0 vote194 views1 answer
Is not sql
SQL
58 votes559 views4 answers
Mysql drop column
SQL
1 vote183 views1 answer
How to remove identity from a column in sql server
SQL