Check Constraint Properties
There are two sets of Check Constraint properties: you can select the object in server explorer to see an abbreviated set or select the object from the dropdown list at the top of the Properties window to see a fuller set.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
Properties for object selected in Server Explorer
Identity Category
Expands to show properties for Name, and Table.Name
Shows the name of the selected check constraint. To change the name of this constraint, type the text directly in the property field.Table
Shows the table to which the check constraint is applied.Misc Category
Expands to show remaining properties.Expression
Displays the expression for the selected check constraint. For new constraints, you must enter the expression before exiting this box. You can also edit existing check constraints. For more information, see Working with Constraints.
Properties for object selected from the Properties window dropdown
General Category
Expands to show the Expression property field.Expression
Displays the expression for the selected check constraint. For new constraints, you must enter the expression before exiting this box. You can also edit existing check constraints. For more information, see Working with Constraints.Identity Category
Expands to show properties for Name and Description.Name
Shows the name of the selected check constraint. To change the name of this constraint, type the text directly in the property field.Description
Shows text describing this check constraint. You can edit the description by typing into the property field or you can click the ellipsis (…) that appears to the right of the property field and edit the description in the Description Property dialog box.Table Designer Category
Expands to show properties for Check Existing Data on Creation or Re-enabling, Enforce For Inserts And Updates, and Enforce Replication.Check Existing Data On Creation or Re-Enabling
Indicates whether all pre-existing data (data existing in the table before the constraint is created) is verified against the constraint.Enforce For Inserts And Updates
Indicates whether the constraint is enforced when data is inserted into or updated in the table.Enforce Replication
Indicates whether the constraint is enforced when the table is replicated into a different database.