• Article

Check Constraint Dialog Box (Visual Database Tools)

This dialog box appears when you right-click a table definition grid in Table Designer and click Check Constraints. The dialog box contains a set of properties for non-unique constraints attached to the tables in your database. Properties applying to unique constraints appear in the Indexes/Keys dialog box.

Note

If the table is published for replication, you must make schema changes using the Transact-SQL statement ALTER TABLE or SQL Server Management Objects (SMO). When schema changes are made using the Table Designer or the Database Diagram Designer, it attempts to drop and recreate the table. You cannot drop published objects, therefore the schema change will fail.

Options

  • Selected Check Constraints
    Lists available check constraints. To view the properties of a constraint, select it in the list.

  • Add
    Create a new constraint for the selected database table and provide a default name and other values for the constraint. The constraint will not become valid until an expression is entered for the constraint.

  • Delete
    Remove the selected constraint from the table. To cancel the addition of a check constraint, use this button to remove the constraint.

  • General Category
    Expand 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 (Visual Database Tools).

  • Identity Category
    Expand 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
    Describing this check constraint. You can edit the description by typing into the property field or you can click the ellipsis button (…) that appears to the right of the property field and edit the description in the Description Property dialog box.

  • Table Designer Category
    Expand 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
    Specify 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
    Specify whether the constraint is enforced when data is inserted into or updated in the table.

  • Enforce For Replication
    Indicates whether to enforce the constraint when a replication agent performs an insert or update on this table. For more information, see Controlling Constraints, Identities, and Triggers with NOT FOR REPLICATION..