List tables in Db2 database schema

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

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

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.