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 vote346 views2 answers
Plsql function that return a table
SQL
1 vote399 views1 answer
Login to database mysql terminal
SQL
7 votes391 views1 answer
Xampp reset mysql
SQL
0 vote377 views1 answer
Oracle execute package dblink
SQL
3 votes399 views2 answers
Sqlite show table structure
SQL
0 vote362 views1 answer
Oracle sql count occurrences of value in column
SQL
6 votes338 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
2 votes425 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote346 views1 answer
Implizite joins sql
SQL
0 vote352 views1 answer
SQL add a totals of differemt rows of the same id
SQL