Error 1916

Severity

Message text

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

Explanation

This error occurs when you try to create an index with two mutually exclusive create index options. When error 1916 occurs, no index is created.

The following options are not compatible with each other:

ignore_dup_row
allow_dup_row
ignore_dup_key

The following table shows the options that can be used with each type of indexes:

	Index option
Index type	ignore_dup_key	ignore_dup_row	allow_dup_row
Nonunique Nonclustered	Do not use	Do not use	Do not use
Nonunique Clustered	Do not use	Okay to use	Okay to use
Unique Nonclustered	Okay to use	Do not use	Do not use
Unique Clustered	Okay to use	Do not use	Do not use

Action

Use only one of the options.
Use the option appropriate for the type of index being created.

Additional information

Refer to “create index” in the Reference Manual: Commands.

Versions in which this error is raised

All versions