/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 vote280 views1 answer
Sql delete row from table where id
SQL
8 votes219 views1 answer
Script to add datafile to tablespace
SQL
11 votes204 views1 answer
Get ddl materialized view oracle
SQL
5 votes226 views1 answer
Oracle nls parameters
SQL
4 votes192 views2 answers
Postgresql reset sequence
SQL
-1 vote219 views2 answers
Import data from excel to sql server automatically
SQL
2 votes211 views2 answers
Laravel query builder toSql
SQL
0 vote260 views1 answer
Postgres - Login and connect as default user
SQL
0 vote207 views1 answer
On sql table data exists
SQL
0 vote193 views1 answer
Create new table pl sql
SQL

Share