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 vote134 views1 answer
Datatables server side filter where clause
SQL
0 vote124 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote126 views1 answer
Check psql validity function
SQL
0 vote184 views1 answer
TSQL Find csv file in folder
SQL
0 vote132 views1 answer
Mysql max number not returning correct value
SQL
2 votes139 views1 answer
How to get non distinct values in sql
SQL
3 votes142 views1 answer
Oracle list invalid password logon denied
SQL
0 vote130 views1 answer
T-sql update table variale
SQL
0 vote138 views1 answer
Hex string sql becomes int64
SQL
0 vote133 views1 answer
How to print records of employees hired in particular month in oracle
SQL