Query below lists all tables in a Redshift database.
select table_schema, table_name from information_schema.tables where table_schema not in ('information_schema', 'pg_catalog') and table_type = 'BASE TABLE' order by table_schema, table_name;
- table_schema - schema name
- table_name - table name
- One row represents one table in the database
- Scope of rows: all tables in the database
- Ordered by schema and table name
You could also get this
Get this interactive HTML data dictionary in minutes with Dataedo.