/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

1 vote122 views1 answer
Group_concat max length mysql
SQL
0 vote138 views1 answer
Hoq to import database source
SQL
1 vote151 views2 answers
Mysql add column tinyint default 0
SQL
0 vote137 views1 answer
How to get first 10 records of a table in mysql
SQL
6 votes115 views4 answers
Eloquent to sql with bindings
SQL
0 vote125 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote138 views1 answer
Check if database exists sql
SQL
6 votes123 views2 answers
Mysql concatenate two columns into one
SQL
0 vote146 views1 answer
Start stop mysql linux
SQL
7 votes127 views1 answer
Sql management studio display line numbers
SQL