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 vote114 views3 answers
Sql delete all except
SQL
0 vote104 views1 answer
Console output pl sql
SQL
0 vote109 views1 answer
Mysql search like but first exact match
SQL
0 vote129 views1 answer
Full outer join in mariadb mysql
SQL
10 votes57 views1 answer
Oracle view dependencies
SQL
1 vote113 views1 answer
Sql try catch
SQL
0 vote99 views3 answers
Joins and views sql
SQL
0 vote139 views1 answer
Day of the week sqlite
SQL
8 votes121 views1 answer
Oracle search text in all packages
SQL
14 votes117 views1 answer
Oracle alter table add column not null
SQL