In MySQL, CHECK
constraint controls the values in the associated column. In other words, CHECK
constraints ensures that the value in a certain column satisfy a Boolean expression or not.
CHECK
constraint on the "Age" column when the "tblCustomer" table is created. The CHECK
constraint ensures that the customer's age greater or equal to 18 years:
CHECK
constraint on the "Age" column when table already exists into the database:
CHECK
constraint "UC_Customer" from "tblCustomer" table: