Unable to find the Parent table name if the child table is known also

[TruptiYadav]

i know the child table and i have the foreign key with me .
but the DB2 script has been written by someone else and i dont know how to get the prant table name.
is there any way to know the description of the Create table command that was used to create the child table.

in fact i want to know the way through which i can get to see the Create table command that was used to creatte the child table.

[kalexin]

use sysibm.systables or syscat.tables

[chandu031]

use sysibm.systables or syscat.tables

Hi,


The foreign key info is stored in the view SYSCAT.REFERENCES ...

Jus run a query

SELECT REFTABNAME FROM SYSCAT.REFERENCES
WHERE TABNAME = '<CHILD_TABLE>' AND
TABSCHEMA = '<CHILD_TABLE_SCHEMA>'


Similarily you can get the columns of the Child table from SYSCAT.COLUMNS