Error 1916

Severity

16

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:

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

Additional information

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

Versions in which this error is raised

All versions