Home » SQL & PL/SQL » SQL & PL/SQL » knowing the referenced tables
knowing the referenced tables [message #247293] Mon, 25 June 2007 07:24 Go to next message
beetel
Messages: 96
Registered: April 2007
Member
If I have a table which has 5 foreign keys to 5 tables, which 'user_' view should I query? The user_constraints view just gives me the constraint name and type of constraint, but it does not give the referenced table as well as its column.
Any help would be appreciated..
Re: knowing the referenced tables [message #247295 is a reply to message #247293] Mon, 25 June 2007 07:30 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Hi,

Goto this link it may be help you Constraints

Reds
Thangam.
Re: knowing the referenced tables [message #247513 is a reply to message #247295] Tue, 26 June 2007 03:07 Go to previous message
beetel
Messages: 96
Registered: April 2007
Member
Thanks. THat was helpful.
Previous Topic: How to create one procedure to produce 3 output files
Next Topic: T -SQL to PL/SQL conversion
Goto Forum:
  


Current Time: Sun Dec 11 02:24:29 CST 2016

Total time taken to generate the page: 0.07898 seconds