sql - Can I set ignore_dup_key on for a primary key?

Question

I have a two-column primary key on a table. I have attempted to alter it to set the ignore_dup_key to on with this command:

ALTER INDEX PK_mypk on MyTable
SET (IGNORE_DUP_KEY = ON);

But I get this error:

Cannot use index option ignore_dup_key to alter index 'PK_mypk' as it enforces a primary or unique constraint.

How else should I set IGNORE_DUP_KEY to on?

Answer 1

ALTER TABLE [TableName] REBUILD WITH (IGNORE_DUP_KEY = ON)