Trigger to delete record on parent & child tables

[qazz]

Greetings!

Is there a trigger way to delete a particular record on parent table and automatically delete related records on child table?

Thank you,

Qazz

 

[JamesLean]

CREATE TRIGGER mytrigger
  ON parent
  FOR DELETE
AS

DELETE child
FROM child c JOIN deleted d ON c.fk_col = d.pk_col

--James

 

[SQLSister]

It is better to set up cascading deletes as these are more efficient than triggers.

 

[qazz]

Thank you James & SQL Sister.

SQLSister is suggesting that "It is better to set up cascading deletes as these are more efficient than triggers."

How can i do that?

Thanks,

Qazz

 

[SQLSister]

Simplest way is in ENterprise Manger, go to the table design form. Select the manage relationships button. Set up a relationship to the other child table. Then you can select cascade update and delte on the form.