sql check
snippet in sql

sql constraint check value in list

user9303

ALTER TABLE <table>
ADD CONSTRAINT chk_val CHECK (col in ('yes','no','maybe'))

sql constraint check value in list

user2056

CREATE TABLE test(
    _id BIGINT PRIMARY KEY NOT NULL,
    decision NVARCHAR(5),
    CHECK (decision in ('yes','no','maybe'))
);

check sql

user6551


CREATE TABLE Persons
(

    ID int NOT NULL,

   
LastName varchar(255) NOT NULL,

   
FirstName varchar(255),

   
Age int,

   
CHECK (Age>=18)

); 

sql check

user2436

Adds a constraint that limits the value which can be added to a column.
Example 1 (MySQL): Makes sure any users added to the users table are 18
or over.
CREATE TABLE users (
first_name varchar(255),
age int,
CHECK (age>=18)
);
Example 2 (MySQL): Adds a check after the table has already been
created.
ALTER TABLE users
ADD CHECK (age>=18);