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

7 votes301 views4 answers
Lowest salary in sql
SQL
0 vote334 views1 answer
Python dictionary to sql update
SQL
1 vote233 views1 answer
Mysql see column types
SQL
0 vote303 views1 answer
Possgress drop if exists view
SQL
0 vote273 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote318 views1 answer
PostgreSQL types and C# types
SQL
7 votes286 views1 answer
Oracle reset sequence
SQL
2 votes282 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote239 views2 answers
Show sql logs in spring boot
SQL
0 vote297 views1 answer
How to reset the database value in SQL server
SQL