Check Constraints Property Page
This property page contains a set of properties for constraints (except unique constraints) attached to the tables in your database. Properties applying to unique constraints appear on the Indexes/Keys property page.
Table Name
Shows the name of the selected table in your diagram. If more than one table is selected in your diagram, only the name of the first table is visible.
Selected Constraint
Shows the name of the constraint whose properties you are viewing. To view the properties of a different constraint, select a constraint from the drop-down list.
New
Choose this button to create a new constraint for the selected database table. Enter properties for the index. For more information, see Attaching a New Check Constraint to a Table or Column.
Delete
Choose this button to remove the selected constraint from the database. For more information, see Deleting a Check Constraint.
Constraint name
Shows the name of the constraint whose properties you are viewing. Use this control to modify the name of the constraint. For more information, see Modifying a Check Constraint.
Constraint expression
Shows the SQL syntax of the selected check constraint. For new constraints, you must enter the SQL syntax before exiting this box. You can also edit existing check constraints. For more information, see Defining a Check Constraint Expression.
Check existing data on creation
When selected, this option ensures that all data that exists in the table before the constraint was created is verified against the constraint.
Enforce constraint for INSERT and UPDATE
Enforces the constraint when data is inserted into or updated in the table.
Enforce constraint for replication
Enforces the constraint when the table is replicated into a different database.