WHERES MY PRIMARY KEY?????

[howzatUK]

How can i find the name of a primary key in oracle? where can i find the name of the primary key and what fields of a tbale make up that primary key?

Thanks

a desperate novice

 

[haste]

Use the user_constraints table. constraint_type set to 'P' indicates a primary key constraint

select *
from user_constraints
where constraint_type = 'P'
and table_name = <table_name>

 

[haste]

Correction, use the user_con_constriants table for the colunms. This statement ought to help.

select B.COLUMN_NAME, B.TABLE_NAME
from USER_CONS_COLUMNS B, user_constraints A 
where A.conStraint_type = 'P'
and A.table_name = <table_name>
and b.constraint_name = a.CONSTRAINT_NAME