Dropping existing Primary key
ALTER TABLE [TABLE1]
DROP CONSTRAINT [pkPartIdPartRevTestCode]
Creating New Primary key
ALTER TABLE
ADD
CONSTRAINT pkPartIdTestIdSupplierCode PRIMARY KEY (PartId,
TestCodeId, SupplierCode);
ALTER TABLE [TABLE1]
ALTER TABLE
ADD
CONSTRAINT pkPartIdTestIdSupplierCode PRIMARY KEY (PartId,
TestCodeId, SupplierCode);
Comments
Post a Comment