Query to list number of records in each table in a database

[sql]

SELECT SCHEMA_NAME(schema_id) AS [SchemaName],
[Tables].name AS [TableName],
SUM([Partitions].[rows]) AS [TotalRowCount]
FROM sys.tables AS [Tables]
JOIN sys.partitions AS [Partitions]
ON [Tables].[object_id] = [Partitions].[object_id]
AND [Partitions].index_id IN ( 0, 1 )
— WHERE [Tables].name = N’name of the table’
GROUP BY SCHEMA_NAME(schema_id), [Tables].name;

[/sql]

Posted on 19 de Novembro de 2019 by . This entry was posted in Code Snippets, SQL Server. Bookmark the permalink.

Comments are closed.