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

14 votes185 views4 answers
Sql compiler
SQL
0 vote177 views1 answer
Sql server remove enter from string
SQL
0 vote176 views2 answers
How to tun mysql on ubunto
SQL
0 vote173 views1 answer
Parsing float to int in mysql
SQL
0 vote213 views1 answer
Mysql backup query
SQL
0 vote236 views1 answer
Prisma transaction
SQL
1 vote177 views1 answer
Oracle explain plan
SQL
-1 vote178 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote210 views1 answer
Connect laravel to mysql on mac
SQL
10 votes209 views4 answers
Fetch first 5 characters of the string in sql
SQL