Home » SQL & PL/SQL » SQL & PL/SQL » Foreign key constraint (9I)
Foreign key constraint [message #303151] Thu, 28 February 2008 03:07 Go to next message
jhedshi
Messages: 13
Registered: February 2008
Junior Member
there is a foreigh key constraint on a table
i found the constarint name using this query:

select * from all_constraints
where table_name = 'X'
AND CONSTRAINT_NAME LIKE 'AJ_UK';

i got the details

HOW to get the name of the column on which this constratint exists.

Regards
Re: Foreign key constraint [message #303153 is a reply to message #303151] Thu, 28 February 2008 03:10 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Did you read This? What makes you think that this is an Expert question? (It's not in case you're not sure)
In answer, look at the user_cons_columns table
Re: Foreign key constraint [message #303303 is a reply to message #303151] Thu, 28 February 2008 16:31 Go to previous message
Barbara Boehmer
Messages: 8621
Registered: November 2002
Location: California, USA
Senior Member
Please see the section on the USER_CONS_COLUMNS data dictionary view in the online documentation:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/statviews_1042.htm#i1575870
Previous Topic: Group By Case
Next Topic: compiled with errors
Goto Forum:
  


Current Time: Fri Dec 02 18:57:28 CST 2016

Total time taken to generate the page: 0.26175 seconds