Can I set ignore_dup_key on for a primary key?
Posted
by Mr. Flibble
on Stack Overflow
See other posts from Stack Overflow
or by Mr. Flibble
Published on 2010-04-07T16:33:15Z
Indexed on
2010/04/07
16:43 UTC
Read the original article
Hit count: 192
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?
© Stack Overflow or respective owner
