CHECK constraints are applied to rows generated as candidates for INSERT and UPDATE operations.
You cannot specify CHECK constraints for Identity columns.
If the condition is met or the proposed INSERT or UPDATE contains NULLs, the operation is permitted.
If the condition is not met, an error is reported as a constraint violation. See CREATE TABLE.
For character data, constraints are checked using the current session collation. Therefore, a value may meet the constraint for one collation and violate the constraint for another collation.
Also see Semantic Constraint Specifications .