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 vote363 views1 answer
Search all sql tables for a value
SQL
4 votes392 views4 answers
Mysql get date from datetime
SQL
0 vote354 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote337 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote328 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote339 views1 answer
Sql examples from framework
SQL
1 vote333 views1 answer
List all triggers in SQL Server
SQL
2 votes312 views1 answer
Match in sql server
SQL
-1 vote342 views1 answer
Spring boot mysql connection properties
SQL
0 vote340 views1 answer
Adding generated time in row mysql workbench
SQL