Queries below list tables in a specific schema.

Query

select tabname as table_name
from syscat.tables
where tabschema = 'schema_name' -- put schema name here
      and type = 'T'
order by tabname

Columns

• table_name - name of the table

Rows

• One row represents one table
• Scope of rows: all tables in the schema
• Ordered by table name

Sample results

You could also get this

Get this interactive HTML data dictionary in minutes with Dataedo.

See live HTML data dictionary sample

Try for free