Previous Topic: -241 - SQL REFERENTIAL INTEGRITY IS NOT ALLOWED ON A DL1/T TABLENext Topic: -243 - ANSI EXTENSION


-242 - CONFLICT ALTERING COLUMN xxx

Explanation

Columns referenced in a constraint CHECK clause or in a Primary, Unique, or Foreign Key cannot be modified or dropped.

The SQLSTATE that equates to this SQL return code is 53S23.

User Response

Issue an ALTER TABLE statement to DROP the constraint or key referencing the column before attempting to modify or alter the column.