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 vote211 views1 answer
Comma seperated join mssql
SQL
0 vote210 views1 answer
Insert thai language sql server
SQL
3 votes199 views2 answers
Oracle for loop
SQL
25 votes232 views6 answers
Import mysql database command line
SQL
0 vote210 views1 answer
Sql case when exists in another table
SQL
0 vote223 views1 answer
Character count sql
SQL
2 votes215 views2 answers
Sql first character
SQL
1 vote223 views1 answer
Moodle query first user access
SQL
4 votes218 views2 answers
Postgre sql create table
SQL
0 vote200 views1 answer
How to get inserted id in sql server
SQL