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 vote163 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote150 views1 answer
Oracle job schedules
SQL
0 vote131 views1 answer
Mysql export and import
SQL
25 votes135 views6 answers
Import mysql database command line
SQL
2 votes191 views5 answers
Install postgresql 10 centos 7
SQL
3 votes131 views1 answer
APEX elapsed time
SQL
0 vote136 views1 answer
Python sql last insertend
SQL
0 vote195 views1 answer
Ora 00001 error catch plsql
SQL
0 vote135 views1 answer
To change the database owner in SQL server
SQL
0 vote92 views1 answer
Mssql view column data type
SQL