Re: Constraint and delete cascade

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 31 Jul 2002 20:28:17 +1000
Message-ID: <DRO19.49366$Hj3.147371@newsfeeds.bigpond.com>

Hi Yaan,

Ummmm, no.

If I understand your question correctly, you have a FK constraint with delete cascade that you want to drop ? Well the constraint is dropped and deleted from the Data Dictionary and that's about it. The column(s) in question are no longer related to any PK or UK and can hence contain any value.

That's all !

Richard
"Yann boucounaud" <yboucounaud_at_ebi-fr.com> wrote in message news:ai8ckb$gvq$1_at_reader1.imaginet.fr...
> Hi everybody
>
> Does someone known what happen physicaly when a constraint with delete
> cascade is dropped ?
> Each tables are dopped and recreated ?
>
> thanks
>
> YB
>
>
>
Received on Wed Jul 31 2002 - 05:28:17 CDT