ALTER TABLE [SCHEMA].[TABLE_NAME] ADD CONSTRAINT PK_NAME PRIMARY KEY (PK_FIELD) WITH ( IGNORE_DUP_KEY = ON ) GO