Home » SQL & PL/SQL » SQL & PL/SQL » Columns in a Compound primary key (Oracle 10g)
Columns in a Compound primary key [message #285710] Wed, 05 December 2007 06:41 Go to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Hi

How to find out column names in compound primary key?

Thanks in Advance
Nat
Re: Columns in a Compound primary key [message #285716 is a reply to message #285710] Wed, 05 December 2007 06:50 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
Hi,

the same way as for one-column constraints, just query COLUMN_NAME from USER_CONS_COLUMNS
Re: Columns in a Compound primary key [message #285719 is a reply to message #285710] Wed, 05 December 2007 06:57 Go to previous message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Thanks FLYBOY!!!!
CHEERS
Previous Topic: about sequence
Next Topic: Changing Order Of Columns after altering table
Goto Forum:
  


Current Time: Sat Dec 03 10:20:32 CST 2016

Total time taken to generate the page: 0.17072 seconds