SQL Constraint Check
SQL Constraint Check:
In this video, we will SQL constraint CHECK and its example.
CHECK - Ensures that all values in a column satisfies a specific condition
Syntax:
CREATE TABLE tbl_name (
col1 data_type CHECK (condition),
... );
OR
CREATE TABLE tbl_name (
col1 data_type,
col2 data_type, ... ,
CONSTRAINT cons_name CHECK(condition1 AND condition2) );
OR
ALTER TABLE tbl_name
ADD CHECK (condition)