Adding Primary key

Dropping existing Primary key

 ALTER TABLE [TABLE1]

DROP CONSTRAINT [pkPartIdPartRevTestCode]

Creating New Primary key

ALTER TABLE  [TABLE1]

ADD CONSTRAINT pkPartIdTestIdSupplierCode PRIMARY KEY (PartId, TestCodeId, SupplierCode);