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 vote301 views4 answers
How to connect form to database
SQL
0 vote282 views1 answer
How to save data in database in mysql node
SQL
0 vote298 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote303 views1 answer
Print mysql
SQL
14 votes370 views1 answer
How to export db from mysql
SQL
0 vote309 views3 answers
Mysql keyword search
SQL
5 votes280 views1 answer
Oracle get nls settings
SQL
-1 vote310 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote344 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote304 views1 answer
Sql server insert inner join
SQL