Home » SQL & PL/SQL » SQL & PL/SQL » find related table
find related table [message #219594] Thu, 15 February 2007 01:39 Go to next message
Messages: 188
Registered: September 2006
Location: INDIA-karnataka
Senior Member
how can i find which are the table refered from the primary key
i want to find all the table which are refered to primary key
eg:column=pk_name_id table=user where and all this pk_name_id is refered from other table
parent and child
can i use dict table to find
Re: find related table [message #219595 is a reply to message #219594] Thu, 15 February 2007 01:41 Go to previous message
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

check in user_constraints / user_cons_columns

Previous Topic: get view name (this.name?)
Next Topic: Drop object type that is marked for delete
Goto Forum:

Current Time: Wed Aug 23 14:35:28 CDT 2017

Total time taken to generate the page: 0.15631 seconds