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

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

Query

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,
         primary_table

Columns

  • 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

Rows

  • 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

Notes

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

Sample results

0
There are no comments. Click here to write the first comment.