Find empty tables in Snowflake

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


select t.table_schema || '.' ||  t.table_name as "table_name"
from information_schema.tables t
where t.table_type = 'BASE TABLE'
    and t.row_count = 0
order by "table_name";


  • 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

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.