The index options ignore_dup_key, ignore_dup_row, and allow_dup_row control what happens when a duplicate key or duplicate row is created with insert or update. Table 13-2 shows which option to use, based on the type of index.
Index type |
Options |
|---|---|
Clustered |
ignore_dup_row | allow_dup_row |
Unique clustered |
ignore_dup_key |
Nonclustered |
None |
Unique nonclustered |
None |
