RE: child and parent tables

look for foreign key constraints in user_constraints tables if a column is referencing to another table.column then it's a CHILD table and the referred table is the MASTER...

look for r_constraint_name column, then use the constraint_name in this column to find out the table where constraint_name = .....

remember a child can have further children...

> ----------
> From: nida Khan[SMTP:nida_at_webstar.co.uk]
> Sent: Wednesday, October 11, 2000 4:37 PM
> To: oracledba_at_lazydba.com
> Subject: child and parent tables
>
> Hi every one,
>
> How can I find out name of child tables of a parent table???(urgent)
>
>
> regards
Received on Wed Oct 11 2000 - 04:47:21 CDT