Background documentation-7024: Alter column not allowed, constraint violation Locate this document in the navigation structure

 

Explanation

The attempt was made to define a new value range for a particular column. The SQL statement fails if the table contains rows that violate the CONSTRAINT definition.

User Response

  1. Choose another CONSTRAINT definition, or do not change the definition at all.

  2. Use a QUERY statement to find out which rows do not meet the CONSTRAINT definition. You can then change or delete these.