"CN" <[EMAIL PROTECTED]> writes:
> I wish foreign key constraint trigger guarantees that rows in
> referensing table are deleted before the rows in referenced table is
> deleted.
> ...
> Does my wish make sense or violate any standard?
Sorry, the SQL standard says that it happens in the current or
Hi!
I wish foreign key constraint trigger guarantees that rows in
referensing table are deleted before the rows in referenced table is
deleted.
Here are one inventory table and two transaction tables serving to
explain the reasons:
CREATE TABLE inv(
warehouse TEXT
,item TEXT
