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 vote156 views1 answer
Oracle tablespace autoextend
SQL
31 votes193 views2 answers
Grant all priviledges to mysql user
SQL
0 vote211 views1 answer
Sqlite3 pragma foreign keys
SQL
3 votes177 views1 answer
Increment integer in table sql
SQL
0 vote222 views1 answer
Radius search with point data in mysql
SQL
0 vote176 views1 answer
Check if database exists sql
SQL
6 votes169 views2 answers
Drop foreign key
SQL
0 vote162 views1 answer
Top frequency in sql server
SQL
2 votes178 views2 answers
Sqlalchemy return id after insert
SQL
1 vote157 views1 answer
Set id count mysql
SQL