Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
ms sql update,insert
TESTE PLATAFORMA
search all tables for string
Trim numbers
Campeonato2DLuizFelipe
SaLLa
Rno 37 boat
Task2
Practice
Get all dates between two given dates
Please log in to post a comment.