Get all tables in Redshift


Andres Canavesi
Aug 23, 2020
Get all tables from a given schema
featured image

Get all tables from a given schema

      
SELECT t.table_name
FROM information_schema.tables t
WHERE t.table_schema = 'mySchema'
ORDER BY 1
      

Recommended posts