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: 185
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: change data to lower
Goto Forum:

Current Time: Tue Oct 25 18:41:51 CDT 2016

Total time taken to generate the page: 0.10820 seconds