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 vote150 views1 answer
How to print sql query
SQL
-1 vote150 views2 answers
Import data from excel to sql server automatically
SQL
0 vote143 views1 answer
Oracle array
SQL
0 vote160 views1 answer
Mysql conf.d exampel
SQL
0 vote154 views1 answer
PSQL use LIKE with timestamps
SQL
7 votes151 views1 answer
Sql pagination oracle
SQL
4 votes182 views2 answers
Convert utc to est sql
SQL
14 votes137 views4 answers
Sql compiler
SQL
0 vote133 views1 answer
Postgresql isnull with max
SQL
2 votes137 views1 answer
Pandas to sql index
SQL