Get all tables in Redshift


Aug 23, 2020
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
      

redshift postgres sql dev