I'm trying to modify a primary key that already exists. I need to add another field to that primary key constraint. What would the syntax be?

currently:
primary key (product, location) constraint prodloc1

Hi there,

First you will have to drop the existing constraint & then create a new one.

Alter table <tabname>
drop constraint prodloc1;

Alter table <tabname>
add constraint primary key (column1, column2);


Regards,

Lloyd