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 vote240 views1 answer
Top 10 rows in mysql
SQL
2 votes220 views1 answer
Postgresql add entry to table
SQL
0 vote228 views1 answer
Mysql drop trigger
SQL
1 vote237 views1 answer
Sql select whole row max column
SQL
1 vote231 views1 answer
Table information in sql server
SQL
1 vote237 views2 answers
Mysql between
SQL
0 vote236 views1 answer
Oracle query archive mode
SQL
1 vote244 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
3 votes244 views2 answers
Update part of a string in mysql
SQL
0 vote208 views4 answers
Sql limit 1 offset 1
SQL