-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