Error 1904

Severity Level 16

Message Text

Cannot specify more than %d column names for index key list. %d specified.

Explanation

This error occurs when more than 16 columns are used to create a composite index. A composite index is an index that uses from 2 to 16 columns.

The following example shows a composite index using objects from the pubs database:

USE pubs

GO

CREATE INDEX idxPubNameCity

ON publishers (pub_name, city)

GO

Action

Modify the CREATE INDEX statement to use no more than 16 columns. For more information, see CREATE INDEX.

See Also