Error 1916

Severity Level 16

Message Text

CREATE INDEX options %s and %s are mutually exclusive.

Explanation

This error occurs when you attempt to create an index with two mutually exclusive create index statement options. The index is not created when this error occurs.

This table shows when to use the CREATE INDEX options:

Index type	Option
Clustered	IGNORE_DUP_ROW \| ALLOW_DUP_ROW
Unique clustered	IGNORE_DUP_KEY
Nonclustered	None
Unique nonclustered	IGNORE_DUP_KEY

Action

Select the correct options for the create index statement. For details on the CREATE INDEX statement, see the Microsoft SQL Server Transact-SQL Reference.