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.

See Also
CREATE INDEX Errors 1000 - 1999
Creating an Index  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.