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 vote148 views1 answer
Table values functions in SQL
SQL
1 vote158 views1 answer
Where not in array sql
SQL
0 vote145 views1 answer
Sql server get date of previous sunday
SQL
0 vote150 views1 answer
PostgreSQL types and C# types
SQL
0 vote155 views1 answer
Mysql update privileges
SQL
2 votes167 views1 answer
Where clause for child record apex
SQL
1 vote155 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
3 votes151 views2 answers
Mysql HAVING
SQL
0 vote150 views1 answer
Start and stop mysql
SQL
4 votes148 views6 answers
Sql select statement
SQL