-643 A CHECK CONSTRAINT OR THE VALUE OF AN EXPRESSION FOR A COLUMN OF AN INDEX EXCEEDS THE MAXIMUM ALLOWABLE LENGTH KEY EXPRESSION
Explanation
The definition of a check constraint
or expression of an index column exceeds the maximum allowable length:
- A check constraint exceeded 3800 UTF-8 bytes. Redundant blank spaces are excluded from this limit.
- A value for an expression for an index exceeded 4000 UTF-8 bytes.
System action
The CREATE TABLE or ALTER TABLE statement failed. The statement cannot be executed.
Programmer response
Change the constraint or expression so that it does not exceed the maximum allowable limit. If it is a check constraint, rewrite the check constraint definition so that it is less than 3800 UTF-8 bytes. You might need to divide a the check constraint into two or more smaller check constraints.
SQLSTATE
54024