Cascading delete and update

Create table depositor

(cname char(20) not null,

acctNo char(10) not null,

primary key (cname, acctNo),

foreign key (cname) references customer

on delete cascade

on update cascade,

foreign key (acctNo) references account)

Previous slide

Next slide

Back to first slide

View graphic version