Is it possible to determine the list of child/parent tables for a
particular table from any system catalog tables? Using the
syscat.tables I'm able to retrieve the no of dependent parent/child
tables but unable to determine the list of dependent table name(s)
Example :
For a simple department-employee relationship, the following query
gives the count of parent/child tables but not the table names(s).
db2 => select tabname, parents,children from syscat.tables where
tabname = 'DEPA
RTMENT' or TABNAME = 'EMPLOYEE'
TABNAME PARENTS CHILDREN
----------------------------------------------------
DEPARTMENT 0 1
EMPLOYEE 1 0
2 record(s) selected.
Thanks,
Sam.