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 vote109 views1 answer
Mql5 datetime get hour
SQL
1 vote122 views1 answer
Select last row from SQL Table
SQL
2 votes149 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote121 views1 answer
Oracle character index
SQL
0 vote111 views2 answers
Update all linkedserver tables with openquery on db
SQL
16 votes115 views6 answers
Insert sql
SQL
22 votes124 views3 answers
How to join three tables in sql using joins
SQL
2 votes127 views6 answers
Mysql change timezone
SQL
0 vote128 views1 answer
How to combine first and last nae into one columb sql
SQL
6 votes126 views2 answers
Postgresql restore from dump
SQL