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

2 votes153 views3 answers
Sql delete duplicate
SQL
22 votes215 views4 answers
Mysql date format
SQL
0 vote159 views1 answer
On delete set default
SQL
0 vote139 views1 answer
Default column value in sql same as other column
SQL
1 vote162 views1 answer
Oracle drop job if exists
SQL
3 votes140 views1 answer
Postgresql cast
SQL
0 vote139 views1 answer
Show size of all tables postgres
SQL
1 vote140 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote253 views1 answer
Sql server query all database objects
SQL
0 vote172 views3 answers
Call to undefined function mysql_connect()
SQL