Skip to main content

Check Constraints (SQL Server, MySQL, PostgreSQL)

How to create and use check constrains in supported databases

SqlDBM Support avatar
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:

  1. 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

Did this answer your question?