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 vote107 views1 answer
Increment id in mysql
SQL
2 votes116 views1 answer
Sqlite show table indexes
SQL
0 vote111 views1 answer
Pgsql is not permitted to log in
SQL
0 vote111 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote108 views1 answer
User defined variables in sql
SQL
0 vote124 views1 answer
Sql select inside select sub query
SQL
0 vote113 views1 answer
How to use group_concat in sql server
SQL
0 vote125 views1 answer
Convert polygon to text in mysql
SQL
4 votes142 views2 answers
Dbms output
SQL
3 votes183 views1 answer
Mysql group_concat distinct
SQL