Export (0) Print
Expand All
Expand Minimize

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.

NoteNote

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. For more information, see Controlling Constraints, Identities, and Triggers with NOT FOR REPLICATION..

Community Additions

ADD
Show:
© 2015 Microsoft