A check constraint can be applied to one or multiple columns (at row level) to ensure that all values match the constraint parameters.
Create a check constraint:
Using Database explorer
2. Using table properties
Check constraint properties
You may:
• set a name
• enter the expression
• enable the "Not Enforced" status
• enter a description