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 vote151 views2 answers
Script all indexes in a database
SQL
0 vote151 views1 answer
Sql requete number pair
SQL
1 vote136 views1 answer
Mysql get last insert id
SQL
6 votes149 views2 answers
Mysql first day of month
SQL
0 vote177 views1 answer
Eliminate zero from integer mysql
SQL
0 vote157 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
3 votes142 views1 answer
DB: in eloquent using sql
SQL
1 vote179 views1 answer
Epoch time converter in snowflake
SQL
-1 vote178 views2 answers
Sql truncate number
SQL
1 vote157 views2 answers
Sql insert timestamp
SQL