Re: Foregin key

From: Roland Carlsson <roland.c_at_swetravel.se>
Date: Tue, 8 Jan 2002 10:53:21 +0100
Message-ID: <3c3ac191@d2o21.telia.com>

I'll take your answer that I must do it that way. I don't want to have the cascade-option on always so I was hoping for a way round. Recreate all f-keys would be close to the same amount of work since I have to recreate them to their orginal state.

Thanks
Roland

"Roman Mirzaitov" <rmirzaitov_at_kt.kg> skrev i meddelandet news:g3z_7.8293$cD4.15241_at_www.newsranger.com...
> In article <3c3aaec6_at_d2o21.telia.com>, Roland Carlsson says...
> >
> >Is there any way to force cascade when deleting from an structure with
> >foreign keys (they are not set with cascade option when createded)
> >
> >Thanks in advance
> >Roland Carlsson
>
> Hi,
> you can drop constraint and recreate it with cascade option.
>
> Regards,
>
>
> --
> Roman Mirzaitov
> Brainbench MVP for Oracle Administration
> www.brainbench.com
Received on Tue Jan 08 2002 - 03:53:21 CST