Check Constraints

The Check constraint page displays the check constraints that are defined for this table. You can add a new constraint, view a constraint definition, or remove a constraint. To create a new constraint, click Add. To remove a constraint, click Remove. To view the definition of a constraint, click Definition. You cannot change the constraint definition once the constraint is created. If you want to change a check constraint, you must first delete the constraint and then recreate it.

To view the SQL used to build the constraint, select a constraint and click Show SQL. Once the table is created, Show SQL is unavailable unless a change is made.

The columns available in the check constraint grid are:

Name
The SQL name of the constraint.

Check condition
The definition of the check constraint.

The constraint is created when you click OK on the Table Definition dialog.