ON UPDATE CASCADE

Script to try for ON UPDATE CASCADE

drop table cust,custbase

Create table custbase (id int primary key,nm char(10))
insert into custbase values (1,’a’)
insert into custbase values(2,’b’)
insert into custbase values(3,’c’)

Create table cust (custid int references custbase(id) ON UPDATE CASCADE, custname char(10))
insert into cust values (1,’Manish’)
insert into cust values (1,’Manish1′)

insert into cust values (2,’Ashish’)
insert into cust values (2,’Ashish1′)

insert into cust values (3,’Nish1′)
insert into cust values (3,’Nish2′)

select * from custbase
select * from cust

Update custbase set id=100 where id=1