Queries below list tables in a specific schema.
select tabname as table_name from syscat.tables where tabschema = 'schema_name' -- put schema name here and type = 'T' order by tabname
- table_name - name of the table
- One row represents one table
- Scope of rows: all tables in the schema
- Ordered by table name
You could also get this
Get this interactive HTML data dictionary in minutes with Dataedo.