-544 THE CHECK CONSTRAINT SPECIFIED IN THE ALTER TABLE STATEMENT CANNOT BE ADDED BECAUSE AN EXISTING ROW VIOLATES THE CHECK CONSTRAINT
Explanation
An existing row violates the check constraint specified in the ALTER TABLE statement.
System action
The statement cannot be processed. The check constraint definition is not added to the table. The table definition is unchanged.
Programmer response
Examine the check constraint definition that was specified in the ALTER TABLE statement and the data in the table to determine why the ALTER TABLE statement was rejected.
You
can determine which rows violated the check constraint by using the
SELECT statement, negating the check constraint in the WHERE clause.
For example:
SELECT * FROM table WHERE (NOT (check-condition));
SQLSTATE
23512