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 vote342 views1 answer
Neo4j command to run script file
SQL
0 vote334 views1 answer
Sql gather statistics to increase performance
SQL
0 vote316 views1 answer
Php get closest location by latitude longitude
SQL
0 vote312 views1 answer
Mysql group by range
SQL
0 vote326 views1 answer
Const pool = mysql.createpool()
SQL
1 vote311 views1 answer
Mysql best tutorial for beginners
SQL
0 vote310 views1 answer
Tsql generate rows
SQL
0 vote313 views1 answer
Join in update query in mysql
SQL
16 votes335 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote297 views1 answer
Mysql column start with string
SQL