IGNORE_DUP_KEY = { ON | OFF }
Specifies the response type when an insert operation attempts to insert duplicate key values into a unique index. The IGNORE_DUP_KEY option applies only to insert operations after the index is created or rebuilt. The option has no effect when executing CREATE INDEX, ALTER INDEX, or UPDATE. The default is OFF.
ON
A warning message occurs when duplicate key values are inserted into a unique index. Only the rows violating the uniqueness constraint fail.
OFF
An error message occurs when duplicate key values are inserted into a unique index. The entire INSERT operation is rolled back.
Comments