Friday, October 12, 2018

Script Finding All Non Empty Tables in SQL Server

Categories:

Hi all,

Below is script for finding all non empty tables in SQL Server. I found it from here , I have used it and it works. So I documented here for archive.


SELECT 'Table Name'=convert(char(25),t.TABLE_NAME),
      'Total Record Count'=max(i.rows)
FROM sysindexes i, INFORMATION_SCHEMA.TABLES t
WHERE t.TABLE_NAME = object_name(i.id)
      and t.TABLE_TYPE = 'BASE TABLE'
GROUP BY t.TABLE_SCHEMA, t.TABLE_NAME
HAVING max(i.rows)>0

Spread The Love, Share Our Article

Related Posts

No Response to "Script Finding All Non Empty Tables in SQL Server"

Post a Comment