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 vote289 views1 answer
Age postgres
SQL
0 vote297 views1 answer
Ansi sql count duplicate rows
SQL
1 vote274 views1 answer
Oracle check table space
SQL
0 vote291 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote283 views1 answer
Subquery aggregation
SQL
0 vote246 views1 answer
Mysql does collate nopad recognize space
SQL
1 vote446 views3 answers
Create table from existing table in sql
SQL
0 vote276 views1 answer
Sql alter table order by
SQL
0 vote271 views1 answer
Connect postgresql using a connection string
SQL
0 vote268 views1 answer
We are intrested to work with your organization
SQL