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

46 votes387 views4 answers
Create column sql
SQL
5 votes330 views1 answer
Sql select ciunt
SQL
0 vote328 views1 answer
Sql server alter table column nullable
SQL
0 vote345 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
-1 vote367 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote364 views1 answer
Oracle show grants on table
SQL
0 vote312 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote334 views1 answer
Sql check if column exists
SQL
1 vote316 views1 answer
Mysql count multiple columns in one query
SQL
0 vote332 views1 answer
Postgresql combine values in one field
SQL