Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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.
sqlserver
Transpose group per sequence
SQL SERVER 2012 how to split records in a column separated by delimiter
ASSESSMENT2
Rno 37 boat
Names
Insert With Output Cluase
SQL flight 2
Cine latinoamericano
megha
stackse - search stackoverflow differently
Please log in to post a comment.