Find tables with names with specific suffix in Db2 database

Query below finds tables which names end with specific sufix, e.g. tables with names ending with 'REGION'.


select t.tabschema as schema_name,
       t.tabname as table_name
from syscat.tables t
where t.type ='T'
and t.tabname like'%REGION'
order by schema_name,


  • schema_name - name of schema table was found in
  • table_name - name of found table


  • One row represents a table
  • Scope of rows: all found tables
  • Ordered by table name, schema name

Sample results

List of tables ending with 'REGION'.

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.