|Subject||Re: SQL spec. and order of delete operations|
> > What behavior is SQL stand. compliant ?event
> the spec often leaves implementation out of the equation. I'd say all
> sequences you have observed are quite valid.Alan I am not sure.
If I understand sql:2003 spec. correctly, then order shall be :
(If we suppose, that referential constraint is IMMEDIATE and triggers
are FOR EACH ROW ... which is case of Firebird, as I think.)
1. Befor master trigger
2. referential constraint (if their <constraint check time> is
IMMEDIATE, which is default) are procesed ...
2.1 Before delete detail
2.2 After delete detail
3. After delete master