Query to list all the tables and table names under a schema in Redshift



Query to list all the tables and table names under a schema in Redshift

select t.table_name
from information_schema.tables t
where t.table_schema = 'schema_name' -- put schema name here
and t.table_type = 'BASE TABLE'
order by t.table_name;



Leave a Reply

Your email address will not be published. Required fields are marked *