Create a Check Constraint

1

Locate the required table in either a diagram or the Project Browser.

2

Right-click on the table and select the Operations context menu option.

The Operations dialog displays.

3

Add an operation with a name such as CHK_ColumnName.

The CHK_ prefix is optional, but helps to identify the operation.

4

In the Stereotype field select check.

5

Click on the Save button.

6

Select the check constraint operation, then the Behavior tab.

7

In the Initial Code field, enter the entire check constraint clause (for example, col1 < 1000).

8

Click on the Save button.