SQL CHECK

SQL CHECK  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 column.

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.

Example

CREATE TABLE users(uid int NOT NULL,name varchar(255) NOT NULL,CHECK (uid>0))

Share