Find empty tables in Azure SQL Database

This query returns a list of tables without rows in a database.


select schema_name(tab.schema_id) + '.' + as [table]
from sys.tables as tab
    inner join sys.partitions as 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) + '.' +
having sum(part.rows) = 0
order by [table]


  • table - table name with schema name


  • One row: represents one table
  • Scope of rows: only empty tables (without rows)
  • Ordered by: schema and table name

Sample results

Empty tables in the AdventureWorksLT database:

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.