check constraint

Question

how to use check constraint??

Answer 1

It can be used to check the input given in the colum by the user
eg:-

CREATE TABLE Persons (
    ID int NOT NULL,
    Name varchar(25),
    Age int CHECK (Age>=10)
);

The above command checks whether the age entered is greater than equal to 10.