Database Developer Interview Question:

Tell me what is a CHECK constraint?

Submitted by: Muhammad

A CHECK constraint is used to limit the value that is accepted by one or more columns.

E.g. ‘Age' field should contain only the value greater than 18.

CREATE TABLE EMP_DETAILS(EmpID int NOT NULL, NAME VARCHAR (30) NOT NULL, Age INT CHECK (AGE > 18), PRIMARY KEY (EmpID));
Submitted by: Muhammad