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

Dropping a Check Constraint

ALTER TABLE Statement

To drop a check constraint, use the SQL DDL ALTER TABLE statement with the DROP CHECK option. DROP CHECK deletes all check constraints associated with the table.

Example

In the following example, all check constraints associated with the BENEFITS table are dropped.

alter table emp.benefits
   drop check;