The CHECK constraint is used to limit the value range that can be placed in a column.
If you define a CHECK constraint on a single column it allows only certain values for this
If you define a CHECK constraint on a table it can limit the values in certain columns based on
values in other columns in the row.
The Below SQL creates a CHECK constraint on the "P_Id" column when the "Persons"
table is created. The CHECK constraint specifies that the column "P_Id" must only
include integers greater than 0.
SQL Server / Oracle / MS Access:
To allow naming of a CHECK constraint, and for defining a CHECK constraint on multiple columns,
use the following SQL syntax:
MySQL / SQL Server / Oracle / MS Access:
To create a CHECK constraint on the "P_Id" column when the table is already created,
use the following SQL:
To drop a CHECK constraint, use the following SQL:
Your Query was successfully sent!