Get all tables from a given schema
SELECT t.table_name
FROM information_schema.tables t
WHERE t.table_schema = 'mySchema'
ORDER BY 1
Photo by Julia Kicova on Unsplash
Get all tables in Redshift
Reading Time: < 1 minutes