|Subject||Re: on delete cascade|
> A detail record can not exist without a master.Exactly my point! But the master record is actually being deleted
before the detail.
> the rule says that when a record is deleted from T1,However the record from T1 is being deleted first, followed by the
> any records in T2 that point to T1 must be deleted.
record from T2.
> Your before delete trigger raises the exception.It is raising the exception because the record in T1 does not exist
Isn't this a violation of referential integrity?