How do I determine if a primary Key exists on a particular table and if yes on which columns.
You can if you think you can.
select * from dba_constraints where table_name = '' and constraint_type = 'P'
select * from dba_cons_columns where table_name = ''
[Edited by KenEwald on 03-13-2002 at 10:46 AM]
You shall check the dba_constraints the column constraint_type(if it is P, then it is primary key) for this table.
And with the PK name you shall query the all_cons_columns for the column_name for this pk.