ALTER TABLE IRGROUPS DROP PRIMARY KEY;

ALTER TABLE IRGROUPS
  ADD CONSTRAINT PK_IRGROUPS
  PRIMARY KEY (UNIQUECOLLECTIONID,GROUPID,VCID);