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 vote186 views1 answer
Sql ssrs
SQL
0 vote155 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote132 views1 answer
Mysql find foreign key references
SQL
1 vote180 views3 answers
Drop unique key constraint in sql server
SQL
0 vote159 views1 answer
Sql select min
SQL
0 vote175 views1 answer
Mysql 8 geo to json
SQL
0 vote192 views1 answer
Amount of entries in a table psql
SQL
0 vote194 views2 answers
T sql null or empty string
SQL
0 vote195 views1 answer
Sql sum if
SQL
0 vote185 views1 answer
List all permissions on a table in postgres
SQL