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 vote94 views1 answer
Create date sql
SQL
3 votes95 views1 answer
Set default today mysql
SQL
0 vote109 views1 answer
Primary key multiple colums
SQL
22 votes140 views4 answers
Mysql format date
SQL
0 vote112 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote121 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
4 votes98 views1 answer
Oracle show errors compilation
SQL
6 votes112 views1 answer
Postgresql get year
SQL
0 vote97 views1 answer
Deny select insert update delete sql
SQL
0 vote106 views1 answer
Longtext sql
SQL