Create a Check Constraint

A Check Constraint enforces domain integrity by limiting the values that are accepted by a column.

Access Project Browser or diagram | Table context menu | Operations

Create a Constraint

Step	Action	See also
1	On the Operations dialog, add an operation with a name such as CHK_ColumnName. The CHK_ prefix is optional, but helps to identify the operation.
2	In the Stereotype field select check.
3	Click on the Save button.
4	Optionally, in the Notes field you can type a check constraint comment.
5	Click on the check constraint operation in the Operations list, then select the Behavior tab from the Properties panel on the left of the dialog.
6	In the Initial Code field, enter the entire check constraint clause. For example, col1 < 1000.
7	Click on the Save button.