Sql constraint check value in list

This article is tagged with: Sql constraint check value in list and mysql

sql constraint check value in list

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

sql constraint check value in list

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

This article is tagged with: Sql constraint check value in list and mysql