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 vote179 views1 answer
Call scalar valued function sql
SQL
0 vote220 views1 answer
Sql query interview questions githu
SQL
0 vote179 views1 answer
Sql server bool select
SQL
0 vote184 views1 answer
Create a table from one field of another table
SQL
0 vote192 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
2 votes218 views1 answer
Import large .sql files into lampp
SQL
0 vote194 views1 answer
Not between mysql
SQL
6 votes296 views2 answers
Database url postgres
SQL
1 vote203 views1 answer
Mysql show data from table
SQL
-1 vote205 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL