How to find Defined key fields in a table?

[sharifhere]

Folks,

Is it possible to find or display key fields of a tablein oracle 9i? ANy data dictionaries will help??


Please do suggest some ways. Ur replies will be appreciated.

Thanks!
Sharif.S

[Innila]

Hi Sharif,

what do u mean by key fields here?

*** Innila ***

[Barbie]

Yeah.. U can do it.
Dba_constraints view will have primary key constraint name for a table.
Having that constraint name, query dba_cons_columns to get the column name(thats the key field).