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

4 votes243 views1 answer
How to check last gather stats on table in oracle
SQL
2 votes195 views2 answers
Postgres trigger insert into another table
SQL
1 vote277 views1 answer
Sql select contem uma palavra
SQL
0 vote149 views1 answer
How to set field to null in sql
SQL
1 vote191 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote223 views1 answer
Reset postgres table index to next max value
SQL
0 vote204 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote215 views4 answers
Get week day from date in sql
SQL
0 vote272 views1 answer
Varchar2 length in oracle
SQL
1 vote293 views1 answer
Insert column after column mysql
SQL