Home » SQL & PL/SQL » SQL & PL/SQL » Foreign key constraint (oracle,Redhat Linux 4)
Foreign key constraint [message #447826] Thu, 18 March 2010 03:21 Go to next message
Messages: 136
Registered: December 2006
Senior Member
Dear all,

pls give the quary, to get the forignkey constraints and related table fro give table.

urget plz.
Re: FORIGNKEY CONSTRAINT [message #447829 is a reply to message #447826] Thu, 18 March 2010 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Do not put your title in UPPER case
2/ Try to post in english
3/ Search before posting, do you think you are the first to ask this?
4/ Post what you tried
5/ Do not post words like urgent but post in the way people will give the answer at the first post without having to ask you stuff

Re: FORIGNKEY CONSTRAINT [message #447834 is a reply to message #447826] Thu, 18 March 2010 03:36 Go to previous message
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
You can use..
user_constraints ,user_cons_columns Two get the Information for the constraint type 'R'

sriram Smile
Previous Topic: Removing Duplicate Rows when condition is matched
Next Topic: leftouter join for below scenario
Goto Forum:

Current Time: Tue Jul 25 00:09:51 CDT 2017

Total time taken to generate the page: 0.11146 seconds