Home » SQL & PL/SQL » SQL & PL/SQL » how to know which column hold primary key
how to know which column hold primary key [message #200682] Tue, 31 October 2006 22:46 Go to next message
talk2dipankar
Messages: 3
Registered: October 2006
Location: Kolkata,India
Junior Member
i have a problem...

there is a table 'DLE_DATA' which has 3 column...

one of them holds primary key..

i want to get which column gets primary key...

i used 'select * from cols' as well as 'select * from user_constraints' but it does not fulfill my needs...

Re: how to know which column hold primary key [message #200684 is a reply to message #200682] Tue, 31 October 2006 22:50 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Try USER_CONS_COLUMNS

Ross Leishman
Re: how to know which column hold primary key [message #200688 is a reply to message #200684] Tue, 31 October 2006 23:03 Go to previous message
talk2dipankar
Messages: 3
Registered: October 2006
Location: Kolkata,India
Junior Member
Thanks a lot...

It is working Fine
Previous Topic: How To Create OS folder froom PL/SQL
Next Topic: doubt in cursor
Goto Forum:
  


Current Time: Fri Dec 02 14:12:59 CST 2016

Total time taken to generate the page: 0.10207 seconds