Answers for "check command sql"

sql constraint check value in list

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

sql query checker

CREATE TABLE employee

   ( employee_id VARCHAR(20),

    Name VARCHAR (20),

    Address VARCHAR (20),

    Mobile_no  SMALLINT);