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'
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'