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

1 vote193 views1 answer
Oracle insert multiple rows into same table
SQL
19 votes206 views3 answers
How to change column type psql
SQL
0 vote188 views1 answer
Oracle sql log to console
SQL
0 vote178 views1 answer
Postgresql delete multiple rows
SQL
1 vote192 views1 answer
Oracle sequence last_number
SQL
14 votes181 views2 answers
How to auto increment in sql
SQL
3 votes190 views1 answer
Postgres add not null to existing column
SQL
0 vote176 views4 answers
Sql year
SQL
0 vote243 views1 answer
Oracle simple quote
SQL
5 votes172 views1 answer
Oracle ORA-00054 origin
SQL