Re: delete cascade

From: David Cressey <cressey73_at_verizon.net>
Date: Wed, 18 Apr 2007 16:38:36 GMT
Message-ID: <gQrVh.19078$Yh.11910@trndny03>

"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message news:FepVh.25684$PV3.261993_at_ursa-nb00s0.nbnet.nb.ca...

> The normal effect of a constraint is simply to block any inconsistent
> update. You gave an english phrase suggesting all foreign keys should
> cascade deletes, and I gave a similar english phrase suggesting they
> should not. Both are useful.

I'm taking "inconsistent update" to mean "an update that would leave the database in an inconsistent state".
Is my reading correct? And, if so, do the two phrases mean the same thing? Received on Wed Apr 18 2007 - 11:38:36 CDT