Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
check constraint
CREATE TABLE person (id INTEGER PRIMARY KEY NOT NULL, name TEXT, age INTEGER, genderid INTEGER) insert into person(id,name,age,genderid)values(1001,'yokesh',19,1) insert into person(id,name,age,genderid)values(1002,'rajesh',19,-1) alter table person add constraint age_const check (age>18 and age<=55) insert into person(id,name,age,genderid)values(1003,'rajesh',55,-1) select* from person alter table person drop constraint age_const insert into person(id,name,age,genderid)values(1004,'ramh',99,1) select* from person
run
|
edit
|
history
|
help
0
SQL Directives Order of Execution
Yan_1st_wall
Libros
Exam_Final
SI 1
Exam_1
SQL_leetcode
Shalvika's Query
Demo
viernes_ alumnos