Cascading Delete (trigger?) 1

[Affleck]

Hi again evrybody, im back with another simple question (hopefully)

How do I create a trigger so that when a record is deleted from a parent table all related child records are deleted also?

Ive done this in the past by enforcing Ref Integrity in Access but im using MS Sql now.

Thanks in advance. ;-)

 

[Tim1]

Hiya

It is quite simple, you just need to create a trigger to do this:

CREATE TRIGGER (name) ON (table) FOR DELETE AS

DELETE query(s)



There is a table called 'deleted' which contains the rows that have been deleted from the main table, which you can reference to cascade your deletes down. It is the same structure as the MAIN table you have deleted rows from.

HTH

Tim

 

[Affleck]

Cheers!!! seems to work fine