AlterTableConstraintModificationStatement
Defines modifications to a table constraint.
True if the modification is for all constraints.
Specifies that constraint is enabled or disabled. When disabled,
future inserts or updates to the column are not validated against the
constraint conditions.
Names of constraints to be modified. Will have zero elements if All is true.
Specifies whether the data in the table is or is not validated against a
newly added or re-enabled FOREIGN KEY or CHECK constraint.
Defines which one of WITH CHECK or WITH NOCHECK were used.
No Check is the default for this class(if nothing was explicitly mentioned),
since these are reenabled constraints (Books online).