Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: SQL Query

Dependent Tables in DB2

Published March 26th, 2019 - by

Have you ever had a need to quickly find out if a DB2 table has any dependencies, i.e. foreign key relationships to it and from it? The following SQL query will show all parent tables (tables that the table references with its foreign keys) as well as all child tables (tables that reference the table Continue Reading