Subject Re: assign same trigger to different tables
Author godefcha
>
> Consistent would be the better term ;-). Tracking changes in a
> BEFORE [OPERATION] trigger would mean, that data which for example
> don't fulfill a CHECK constraint would be tracked too ...
>
> Regards,
> Thomas Steinmaurer
> http://www.iblogmanager.com

Do I understand well if I say that the above mean that the order of
evaluation is the following :

all BeforeInsert triggers
check constraints
all AfterInsert triggers.

IOW, I should be able to transform unacceptable data according to the
constraints to acceptable data in SQL code placed in before...
triggers.

Further, when are the referential integrity constraints checked ?