Index Options

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.

This table 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