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
Printable View
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
Hi Sharif,
what do u mean by key fields here?
*** Innila ***
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).