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 vote343 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote390 views1 answer
Sql out file formate
SQL
6 votes356 views5 answers
Mysql get last insert id
SQL
13 votes369 views1 answer
Sql join 3 tables on id
SQL
0 vote406 views1 answer
Insert using condition postgres
SQL
7 votes364 views2 answers
Create index mysql cli
SQL
2 votes350 views1 answer
Get first 2 letter in sql
SQL
0 vote339 views1 answer
Sql query for displaying age from oldest to youngest
SQL
3 votes369 views1 answer
Sql add two values together
SQL
1 vote344 views2 answers
Mysql current user
SQL