How to list all the tables of a schema in Redshift

Run the below select statement to list all the tables of a schema where schemaname is the name of the schema.

select table_name from information_schema.tables where table_schema= 'schemaname' and table_type = 'BASE TABLE'
See also  How to list all the databases in a Redshift cluster