Does Cascade Update and Delete fire child table triggers?

gideon29
gideon29 used Ask the Experts™
on
In MS SQL, if you delete a record that has a foreign key relationship with another table and has cascade update and delete selected, will it fire the update or delete triggers of the foreign key table?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Yes it will.

Author

Commented:
Do you know of a page I can find to reference this fact?  I didn't see it in trigger descriptions on the microsoft site.
Commented:
I found this :

http://msdn.microsoft.com/en-us/library/aa933119(SQL.80).aspx

(Section of the link)
ON DELETE CASCADE

Specifies that if an attempt is made to delete a row with a key referenced by foreign keys in existing rows in other tables, all rows containing those foreign keys are also deleted. If cascading referential actions have also been defined on the target tables, the specified cascading actions are also taken for the rows deleted from those tables.

Author

Commented:
Thx for the help!

Author

Commented:
Answered.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial