Modifying Schema, View, Table, and Routine Definitions › Maintaining Tables › Modifying a Check Constraint

Modifying a Check Constraint

To modify a check constraint, follow these steps:

1. Drop the existing check constraint, as described above
2. Add the new check constraint, as described above

Note: Use SELECT SYNTAX from SYSCA.SYNTAX to display the existing check constraints before dropping it:

select syntax from sysca.syntax
 where schema='EMP' and
 table = 'BENEFITS';

Example

alter table emp.benefits
   drop check;

alter table emp.benefits
   add check ( fiscal_year > 1930 );