-767 MISSING OR INVALID COLUMN SPECIFICATION FOR INDEX index-name
Explanation
The CREATE INDEX statement failed for one of the
following reasons:
- An index on a non-auxiliary table must specify the columns on which the index is defined.
- An index on an auxiliary table must not have a column specification.
System action
The statement cannot be processed.
Programmer response
Correct the syntax of the CREATE INDEX
statement.
- To create an index on a non-auxiliary table, specify the columns on which the index is defined.
- To create an index on an auxiliary table, do not specify the name of any column.
SQLSTATE
42626