From: "Dmitry Yemanov" <dimitr@...>

> "Martijn Tonies" <m.tonies@...> wrote:
> >
> > Might be, but given that our CHECKs are only evaluated on insert/update
> > (and not even on DELETE), could make them useless in certain occasions
> > when referring to other tables.
>
> As per SQL spec, all existing constraints must be checked at the end of

any

> SQL statement. So DELETE shouldn't behave differently, IMHO.

There's something to fix then :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com