Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Foregin key

Re: Foregin key

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Tue, 08 Jan 2002 09:35:08 GMT
Message-ID: <g3z_7.8293$cD4.15241@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:35:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US