Delete contents in two tables at a time

How to delete contents in two tables at a time? When you delete contents in one table then other table contents should also be deleted.

jyothivdaru
Profile Answers by jyothivdaru Questions by jyothivdaru
Apr 9th, 2008
12
3528

Questions by jyothivdaru

SQL

Answer

Showing Answers 1 - 12 of 12 Answers

tariq_oracle
Profile Answers by tariq_oracle

Apr 13th, 2008

with the use of on delete cascade clause
when we deete the parent record child record will be deleted automaticaly

abc.abc555
Profile Answers by abc.abc555

Jun 19th, 2008

ON DELETE CASCADE clause with a FOREIGN KEY constraint specifies that when a row in the parent table is deleted, any matching rows in the child table are also deleted.

krishnaindia2007
Profile Answers by krishnaindia2007

Jun 20th, 2008

You may also use triggers for this purpose. But specifying on delete cascade while defining foreign key constraint is better option.