OraFAQ Forum: Server Administration » Re: Query the name of the primary key of a table

Home » RDBMS Server » Server Administration » Re: Query the name of the primary key of a table

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

Re: Query the name of the primary key of a table [message #371432]

Wed, 18 October 2000 13:29

Prem
Messages: 79
Registered: August 1998

Member

Stefan,

Run this query in SQL*Plus to test. It will prompt you for the table name. Enter the table name (all in caps, or you may have to change the query using upper())

select column_name from user_cons_columns
where constraint_name in (select constraint_name from user_constraints
where constraint_type = 'P' and table_name = '&TABLENAME')

This will display the column which is a primary key. If your primary key is composite (more than 1 column form a primary key), it will display all these columns.

hth

Prem :)

Report message to a moderator

Previous Topic:	Deleting/renaming file created by UTL_FILE
Next Topic:	Table Name

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:16:24 CDT 2024