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 vote143 views1 answer
Regex any word except sql
SQL
0 vote137 views1 answer
Create column that already exists mysql
SQL
0 vote152 views1 answer
How convert into in in sql query
SQL
0 vote125 views1 answer
User defined variables in sql
SQL
0 vote138 views1 answer
Raiserror with nowait
SQL
0 vote127 views1 answer
Array aggre distinct postgres
SQL
1 vote317 views1 answer
Postgres upgrade to superuser
SQL
0 vote133 views1 answer
Suse status MySQL
SQL
1 vote180 views4 answers
Alter schema sql
SQL
0 vote113 views1 answer
Sql trim whitespace
SQL