Find a table by the name in Db2 database

Query below finds tables with specific name in all schemas in a database. In this case it searches for 'XGOREV' table.


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


  • schema_name - name of schema table was found in
  • table_name - name of table (redundant as it should be exactly the same as provided)


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


  1. There migh be more tables than one because different schemas in a database can have tables with the same names

Sample results

List of tables named 'XGOREV'.

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.