List all tables refrencing specific table (by FK) in Db2 database

Query below lists all tables that refrence specific table with foregin keys.


select tabschema  || '.' || tabname as foreign_table,
       '>-' as rel,
       reftabschema || '.' || reftabname as primary_table
from syscat.references
where reftabname = 'EMPLOYEE'
      -- and reftabschema = 'ADMINISTRATOR' -- put your schema name here
order by foreign_table,


  • foreign_table - foreign tables schemas and names - the table you are looking for
  • foreign_table - relationship symbol implicating FK and direction
  • primary_table - primary (rerefenced) tables names with schema name - the table you provided as a parameter


  • One row represents one referencing table
  • Scope of rows: all tables referencing table with provided name (and optionally schema)
  • Ordered by referencing table schema and name


  • There can be more tables with the same name. If that's the case, uncomment where clause and provide schema name

Sample results

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.