Untitled

 avatar
unknown
plain_text
a year ago
488 B
4
Indexable
create table emp(id int primary key, name varchar(20) unique, salary int not null,age int, check(age>30));
insert into emp values(1,'Dasarath',50000,35);
insert into emp values(2,'Ram',60000,40);
insert into emp values(3,'sita',50000,35);
insert into emp values(4,'hanuman',60000,2900000);

create table dept(depid int primary key, deptname varchar(20) unique, age int , empid int, foreign key(empid) references emp(id));
insert into emp values(5,'laxman',60000,29000);
select * from emp;
Editor is loading...
Leave a Comment