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.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

1> always avoid select * from
2> do not use in operator

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions 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.

Answer Question  Select Best Answer