/SQL/SQL query to get all table records count from a database

SQL query to get all table records count from a database

DECLARE @TableRowCounts TABLE ([TableName] VARCHAR(128), [RowCount] INT) ;
INSERT INTO @TableRowCounts ([TableName], [RowCount])
EXEC sp_MSforeachtable 'SELECT ''?'' [TableName], COUNT(*) [RowCount] FROM ?' ;
SELECT [TableName], [RowCount]
FROM @TableRowCounts
ORDER BY [TableName]
GO

Source: mssqltips.com

Similar codes

0 vote201 views1 answer
Mysql insert into select with recursive
SQL
4 votes179 views2 answers
Oracle set date format
SQL
0 vote172 views1 answer
Postgres call view
SQL
0 vote181 views1 answer
Sql how to get courses that i have made prerequisites
SQL
4 votes222 views5 answers
Get last query in codeigniter 4
SQL
0 vote197 views1 answer
Query archive mode
SQL
4 votes218 views2 answers
Postgresql float data type
SQL
0 vote193 views1 answer
Sqlite3 update select
SQL
0 vote178 views1 answer
Authentication in sql server
SQL
1 vote208 views1 answer
Mysql connect bash
SQL