Home » SQL & PL/SQL » SQL & PL/SQL » How to know the columns assigned to a constraint
How to know the columns assigned to a constraint [message #195867] Mon, 02 October 2006 17:47 Go to next message
BOMAYED
Messages: 16
Registered: September 2006
Junior Member
I know how to display the name of the contraint using :

Select constraint_name from DBA_CONSTRAINTS


Now , how do i find out the columns which are assigned to a specific constraint ?

Report message to a moderator

Re: How to know the columns assigned to a constraint [message #195871 is a reply to message #195867] Mon, 02 October 2006 18:26 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
select * from dba_cons_columns
 where owner = :owner
   and constraint_name = :constraint_name;

Report message to a moderator

Previous Topic: pivot query help, order by clause, and not getting results expected (merged 3 threads)
Next Topic: USING INDEX TABLESPACE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 12:10:33 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.