/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 vote381 views1 answer
Sqlite3_open_v2
SQL
1 vote347 views1 answer
Sql server update column based on another table
SQL
0 vote349 views1 answer
Download mysql database to excel in android studio
SQL
0 vote346 views1 answer
Backup a table in sql
SQL
0 vote351 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote409 views2 answers
How to install psql in ubuntu
SQL
0 vote391 views2 answers
Amazon linux postgresql client
SQL
3 votes386 views1 answer
Start mysql server linux terminal
SQL
4 votes360 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
2 votes384 views1 answer
Mysql set value as null
SQL

Share