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 Visual Studio Settings.

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.

See Also

Reference

Check Constraint Dialog Box

Other Resources

Working with Constraints