A check constraint is used to limit the value entered in a field. E.g. we can ensure that field 'Salary' can only have a value greater than 1000 using check constraint-
CREATE TABLE EMP_SALARY(EmpID int NOT NULL, NAME VARCHAR(30) NOT NULL, Salary INT CHECK (Salary > 1000), PRIMARY KEY (EmpID));