Sql

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

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

PREVIOUS	NEXT

Code Example
Sql :: copy data from one table to another mysql
Sql :: how to get date in sql
Sql :: enter mysql command line
Sql :: database timezone
Sql :: how to drop database name in postgresql
Sql :: add time to date sql
Sql :: AND OR NOT operators sql
Sql :: sql number columns
Sql :: flask marshmallow sqlalchemy
Sql :: mysql select distinct date from timestamp
Sql :: create tablespace oracle multiple datafiles
Sql :: Index a database column sql
Sql :: postgresql parse json array
Sql :: mysql min value row
Sql :: user_dependencies
Sql :: create table as select * from table mssql
Sql :: mysql select date from datetime
Sql :: inner join
Sql :: mysql max
Sql :: oracle current session details
Sql :: sql select if two columns are equal
Sql :: How to insert Arabic characters into SQL database
Sql :: mysql create a user
Sql :: sql string function update replace
Sql :: get triggers by query
Sql :: ignore case in string sql
Sql :: database stuck on restoring
Sql :: oracle generate list of dates in between a date range
Sql :: how to define a save method in ruby for sqlite3 databases
Sql :: sql tabelle erstellen