-614 THE INDEX CANNOT BE CREATED OR ALTERED, OR THE LENGTH OF A COLUMN CANNOT BE CHANGED BECAUSE THE SUM OF THE INTERNAL LENGTHS OF THE COLUMNS FOR THE INDEX IS GREATER THAN THE ALLOWABLE MAXIMUM
Explanation
The index could not be created or the length
of a column cannot be changed because the sum of the internal lengths
of the key columns would exceed the allowable maximum. The maximum
permitted key length is as follows:
- For PADDED indexes, the sum of the length attributes of the columns must not be greater than 2000-n, where n is the number of columns that contain null values.
- For NOT PADDED indexes, the sum of the length attributes of the columns must not be greater than 2000-n-2m, where n is the number of nullable columns and m is the number of varying length columns.
System action
The statement cannot be processed. The specified index was not created or the length of the column was not changed.
Programmer response
The definition for the index must be modified (possibly by eliminating one or more key columns) to reduce the length of the key to the permitted maximum.
SQLSTATE
54008