Online Documentation for SQL Administrator for SQL Server

Properties


Use the Properties tab of the Check Constraint Editor to create/edit a check constraint and specify its properties.

 

 

Check Editor - Properties

 

 

Name

Enter a name for the new check, or modify the name of the check being edited.

 

Table

In this field the Table name of the check being edited is displayed.

 

!CheckBox Enabled

Enables/disables the check immediately after it is created.

 

!CheckBox Check existing data

This option specifies whether the data in the table is or is not validated against a newly added or re-enabled check.

 

Condition

This area represents the condition implied by the check constraint.

You can specify any logical (Boolean) expression that returns TRUE or FALSE based on the logical operators. For example, salary >= 15000 AND salary <= 100000.