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.

System_CAPS_ICON_note.jpg 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.

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.

Working with Constraints (Visual Database Tools)
Indexes - Keys Dialog Box (Visual Database Tools)

Community Additions

ADD
Show: