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.

 

 

Learning Center topics

(Alt+F1) | Database Engineering | Physical Data Model | Check Constraint