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

4 votes208 views1 answer
Phone number sql
SQL
0 vote185 views1 answer
Uncomment listen_address=localhost
SQL
6 votes229 views3 answers
Rename column ORACLE
SQL
0 vote213 views1 answer
Mysql grant all on all databases
SQL
0 vote235 views1 answer
How to check rollback status in oracle
SQL
17 votes199 views6 answers
Current date in sql
SQL
0 vote197 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote226 views2 answers
Sql query print strings and int
SQL
1 vote176 views1 answer
Firebase bigquery cloud message
SQL
1 vote196 views1 answer
Mysql limit results to 10
SQL