foreign key default constraint
create table emp40(empid int primary key,empname varchar(20));
insert into emp40 values(1001,'vasu');
insert into emp40 values(1002,'sadineni');
select * from emp40;
create table job40(empid int references emp40(empid),desg varchar(20),sal int,hiredate varchar(20));
insert into job40 values(1,'manager',30000,'13-04-2002');
insert into job40 values(2,'hr',20000,'15-06-2000');
select * from job40;
create table po(id int default 100,name varchar(20),age int);
insert into po values(1,'vasu',23);
insert into po values(2,'vasu',24);
insert into po(name,age) values('vasu',21);
select * from po;