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 vote231 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
4 votes221 views1 answer
Mysql ip address data type
SQL
1 vote210 views2 answers
How to search date in sql query
SQL
1 vote250 views1 answer
Select not matching data with join table
SQL
0 vote163 views1 answer
Now() -1 mysql
SQL
1 vote267 views1 answer
Ora-01950 no privileges on tablespace
SQL
25 votes248 views6 answers
Import database mysql command line
SQL
16 votes200 views2 answers
Mysql date between two dates
SQL
0 vote193 views1 answer
Psql select * from table
SQL
0 vote196 views1 answer
Default column value in sql same as other column
SQL