Check Constraint Dialog Box
These properties appear when you right-click a table definition grid in Table Designer and click Check Constraints. This dialog box contains a set of properties for constraints (except unique constraints) attached to the tables in your database. Properties that apply to unique constraints appear on the Indexes/Keys dialog box.
Note
If the table is published for replication, you must change the schema by using the Transact-SQL statement ALTER TABLE or SQL Server Management Objects (SMO). For more information about the ALTER TABLE statement, see the Microsoft Web site. If you change the schema by using the Table Designer or the Database Diagram Designer, the table will be dropped and re-created. You cannot drop published objects, which might cause the schema change to fail.
Selected Check Constraints
Lists available check constraints. To view the properties of a constraint, click it in the list.Add
Creates a constraint for the selected database table and provides a default name and other values for the constraint. The constraint will not become valid until an expression is specified for the constraint.Delete
Removes the selected constraint from the table. To cancel the addition of a constraint, click this button to remove the constraint.General Category
Expands to show the Expression property field.Expression
Displays the expression for the selected check constraint. For new constraints, you must specify the expression before you close 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 that describes 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 that existed in the table before the constraint was created) is verified against the constraint.Enforce For Inserts And Updates
Indicates whether the constraint is enforced when data is added to or updated in the table.Enforce Replication
Indicates whether to enforce the constraint when a replication agent adds or updates data in this table. For more information, see "Controlling Constraints, Identities, and Triggers with NOT FOR REPLICATION" on the Microsoft Web site.