What is CHECK Constraint?


Check Constraint is used to restrict column values based on conditions while inserting data to the table.

Create table Employee(EmpID int NOT NULL CHECK(EmpID > 10),
EmpName varchar(200) NOT NULL,
Salary int);