.Access this form by selecting the Tables node (within a database) on the
navigation pane, then
select the required table in the
object list and click
the manage constraints icon .
Name
Shows the name of the constraint whose properties you are viewing. Use this control
to modify the name of the 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.
Enforce constraint for replication
Enforces the constraint when the table is replicated into a different database.
Enforce constraint for INSERT and UPDATE
Enforces the constraint when data is inserted into or updated in the table.