Check Options « Constraints « SQL Server / T-SQL

1.The syntax of a check constraint: CHECK (condition)
2.Blocking Empty and Missing Character Input
3.WITH CHECK OPTION says any INSERT or UPDATE statements must meet that where clause criteria
4.A statement that creates a table with two column-level check constraints
5.check constraints coded at the table level
6.Mark constraint with nocheck when creating a constraint