Create a Check Constraint

How To:

To create a Constraint, follow the steps below:

Step

Action

See Also

1

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

 

2

Use the context menu to open the Operations dialog

 

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 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