Subject Triggers technique question
Author Marcin Bury
Hi List

I'm currently creating brand new database for new project and I was
wondering about using triggers "before" or "after".
I.e. if I have the table of invoice headers and the table of invoice items,
when the user wants to delete the invoice (don't ask why) I should use
"before delete" or "after delete" trigger to delete invoice items. Are there
any rules, recommendation, safety and stability issues for choosing "before"
or "after" triggers for updating additional tables.