Editing a Check Constraint

Edit a check constraint to change a condition limiting data inserts for specified columns.

Prerequisites

Before you can edit a check constraint, be sure that the data server containing the appropriate table is running, and you created and established a connection to the data server. Open the table containing the check constraint in the Table Schema Editor.

In the Table Schema Editor, select the Constraints tab for the table for which you want to edit the check constraint.
Expand the Check Constraints folder under Constraints in the directory tree, and highlight the check constraint to edit.

Edit the check constraint settings in the Details pane.

Field	Description
Name	Enter a name for the check constraint.
Definition	Modify the Boolean expression for the check constraint. To add additional column names to this field, click Columns, select columns from the Columns dialog, and click OK.

Select File > Save from the main menu.