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 votes168 views1 answer
Oracle percentage
SQL
18 votes179 views3 answers
Mysql add column default value
SQL
0 vote164 views1 answer
Add SuperUser MySQL
SQL
11 votes159 views6 answers
Distinct sql
SQL
0 vote164 views2 answers
SQL FROM
SQL
5 votes156 views1 answer
Sql add column after another
SQL
0 vote191 views1 answer
Stop psql server windows
SQL
2 votes153 views2 answers
Enable foreign key checks postgres
SQL
0 vote153 views1 answer
Drop constraint in ms sql
SQL
0 vote197 views1 answer
Mysql wsrep ls
SQL