Cascade deleting

[Shahid Murtaza]

i two tables master and detail linked by foreign key, i want when i delete the record in master table then associating detail record should also be deleted,
please help me.

[debasisdas]

You want as u delete a record from the master table its dependent child record will be delete from the child table right ??

for that u need to specify ON DELETE CASCADE in the foreigh key constraint.

[debasisdas]

Try is sample block to create relationship as u asked.

create table master
(
deptno  number(4) primary key, 
deptname varchar2(20)
);
 
create table detail
(
id number(4) primary key,
name varchar2(20) not null,
dno number(4),
constraint mast_det_fk foreign key (dno) references master(deptno) on delete cascade
);
 
 

Hope it solves your problem.