/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 vote362 views2 answers
Postgresql get last 10 records
SQL
0 vote341 views1 answer
Data structures in sql
SQL
0 vote361 views1 answer
Sql convert unix time to date
SQL
6 votes376 views3 answers
Rename column ORACLE
SQL
1 vote374 views1 answer
Pl sql create table from another table
SQL
0 vote349 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
7 votes367 views2 answers
Where keyword sql
SQL
2 votes356 views1 answer
Drop sequence
SQL
0 vote332 views3 answers
Above average salary in sql
SQL
10 votes333 views4 answers
Fetch first 5 characters of the string in sql
SQL