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 vote295 views1 answer
Select place default lat long
SQL
0 vote266 views1 answer
Sql case when exists in another table
SQL
-1 vote268 views3 answers
Psql get last rows
SQL
0 vote275 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
4 votes255 views1 answer
Update table from another table oracle
SQL
0 vote272 views3 answers
Find below average salary in sql
SQL
10 votes273 views1 answer
Oracle all_dependencies
SQL
1 vote296 views1 answer
Group_concat order by
SQL
1 vote309 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote304 views1 answer
Table structure in sql
SQL