Error 1916
Severity Level 16
Message Text
CREATE INDEX options %ls and %ls are mutually exclusive.
Explanation
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 |
Action
Select the correct clauses for the CREATE INDEX statement.