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 vote186 views2 answers
Wordpress change url in database
SQL
1 vote150 views1 answer
Insert column after column mysql
SQL
0 vote158 views1 answer
Reset a table's identity column and remove test records
SQL
1 vote117 views1 answer
Rows to comma separated values in mssql
SQL
1 vote116 views1 answer
Sql upsert
SQL
0 vote132 views1 answer
Mysql set boolean default value
SQL
2 votes126 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote127 views1 answer
Sql select merge multiple values
SQL
1 vote112 views1 answer
How refresh navicat tables to see new tables
SQL
3 votes119 views2 answers
Postgres inner join vs join
SQL