Check Constraints (SQL Server, MySQL, PostgreSQL)

How to create and use check constrains in supported databases

Written by SqlDBM Support

Updated over 4 years ago

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:

2. Using table properties

Check constraint properties

You may:

• set a name

• enter the expression

• enable the "Not Enforced" status

• enter a description