CREATE INDEX options %ls and %ls are mutually exclusive.
This error occurs when you attempt to create an index with two mutually exclusive CREATE INDEX statement clauses. The index is not created when this error occurs.
This table shows when to use the CREATE INDEX clauses:
Index type | Clause |
---|---|
Unique clustered | IGNORE_DUP_KEY |
Nonclustered | None |
Unique nonclustered | IGNORE_DUP_KEY |
Select the correct clauses for the CREATE INDEX statement.
CREATE INDEX | Errors 1000 - 1999 |
Creating an Index |