Subject | Re: assign same trigger to different tables |
---|---|
Author | godefcha |
Post date | 2002-03-07T15:32:09Z |
>Do I understand well if I say that the above mean that the order of
> 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
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 ?