cascade delete trigger

[richey1]

I have 3 tables tblEnquiry, tblExempt, tblAppeal

tblEnquiry is the parent with primary key EnquiryID

tblExempt/tblAppeal have foreign keys set-up to EnquiryID

I now can't delete a record on tblEnquiry where a record exist in one of the other tables. fine ?(i hope) so can i create a trigger that says if the record is deleted in tblEnquiry it cascades down to the other two ?

any help appreciated
thanks
kim

i tried something like

CREATE TRIGGER tg_cascadedelete ON [dbo].[tblEnquiry]
AFTER DELETE
AS
DELETE FROM tblExempt WHERE EnquiryID = tblEnquiry.EnquiryID

 

[swampBoogie]

Define the foreign key constraint with ON DELETE CASCADE instead.

 

[JamesLean]

If that's all you want to do why not specify the cascading delete in the foreign key definitions?

CONSTRAINT FK_name FOREIGN KEY REFERENCES tblEnquiry(EnquiryID) ON DELETE CASCADE

--James