Get list of tables with rows

SQL Server Administration
1

Hello,
in a SQL SERVER 2019 database, I have several thousands of tables.
Is there a way to get the list of only tables with data? (at least 1 row).

Thank you.

Luis

2

hi

hope this link helps :slight_smile:

if you can understand and implement .. that's good

if you need help with the SQL please let me know !!

3

hi

another query

select schema_name(tab.schema_id) + '.' + tab.name as [table]
   from sys.tables tab
        inner join sys.partitions part
            on tab.object_id = part.object_id
where part.index_id IN (1, 0) -- 0 - table without PK, 1 table with PK
group by schema_name(tab.schema_id) + '.' + tab.name
having sum(part.rows) > 0
order by [table]
1 Like
4

Perfect, thank you Harish.

L.