OraFAQ Forum: Server Administration » how to find out primary key in a table.

Home » RDBMS Server » Server Administration » how to find out primary key in a table.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find out primary key in a table. [message #373101]

Tue, 27 March 2001 13:45

shreya
Messages: 15
Registered: March 2001

Junior Member

Hi,

I need all the columns except the primary key from a table.
Can somebody tell me how can i do this using sql.
If possible send me the sql query.

Thanks in advance,
Shashi.

Report message to a moderator

Re: how to find out primary key in a table. [message #373133 is a reply to message #373101]

Wed, 28 March 2001 16:25

CHACKO
Messages: 11
Registered: March 2001

Junior Member

SELECT CONSTRAINT_NAME,CONSTRAINT_TYPE FROM USER_CONSTRAINTS
WHERE TABLE_NAME='EMP';

Report message to a moderator

Re: how to find out primary key in a table. [message #373134 is a reply to message #373101]

Wed, 28 March 2001 16:34

samreen
Messages: 2
Registered: March 2001

Junior Member

Try this

select column_name from ALL_CONS_COLUMNS where Constraint_name=
(select constraint_name from user_constraints where table_name ='TABLE_NAME' and constraint_type='P')

Report message to a moderator