/SQL/Sql constraint check value in list

Sql constraint check value in list

Sql constraint check value in list

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

4

Source: stackoverflow.com

Sql constraint check value in list

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

1

Source: stackoverflow.com

Similar codes

0 vote174 views1 answer
Mysql faster delete
SQL
5 votes117 views1 answer
Mysql get last day of month
SQL
0 vote129 views1 answer
Enable full text search mysql
SQL
5 votes129 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote129 views1 answer
How to install sql in anaconda
SQL
28 votes128 views4 answers
Mysql delete database
SQL
4 votes177 views1 answer
Postgresql list sequences
SQL
-1 vote121 views1 answer
Mysql case when multiple conditions
SQL
0 vote92 views2 answers
Spring properties file for db
SQL
13 votes119 views6 answers
Mysql update from select
SQL

Share