How to find the parent table name using child table

nareshreddy.j · New User Joined: 06 Mar 2007 Posts: 3 Location: bangalore

i created child table referenced to parent table.i forgot the parent table name but i know child table name.can any one help me how to find parent table name? [/b]

saiprasadh · Active User Joined: 20 Sep 2006 Posts: 154 Location: US

Hi

You can find the parent table name in SYSIBM.SYSRELS table.

Select REFTBNAME from SYSIBM.SYSRELS WHERE TBNAME = 'Child Table Name';

Sai

vini_srcna · Posted: Wed Mar 14, 2007 9:14 pm

if you have really created the Child table then you can see it in the DDL also.

nareshreddy.j · New User Joined: 06 Mar 2007 Posts: 3 Location: bangalore

thank you for ur suggession.