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 vote257 views1 answer
Mysql filter based on datediff
SQL
0 vote275 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote282 views1 answer
How to find all children of a record with only parent ID in sql
SQL
4 votes246 views4 answers
Sqlite describe table
SQL
4 votes259 views1 answer
Refresh postgres config
SQL
7 votes270 views3 answers
Sql server reset auto increment
SQL
0 vote245 views1 answer
Mysql function variable
SQL
1 vote268 views1 answer
Sql where max date
SQL
1 vote254 views2 answers
Sql drop multiple columns if exists
SQL
1 vote258 views1 answer
DATE_SUB postgres
SQL