Re: Foregin key

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Tue, 08 Jan 2002 10:45:42 GMT
Message-ID: <q5A_7.8326$cD4.14966@www.newsranger.com>

In article <3c3ac191_at_d2o21.telia.com>, Roland Carlsson says...
>
>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

Well, maybe you'll find useful trigger technique. I mean you can create on delete trigger and control inside when to fire it.

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com

Received on Tue Jan 08 2002 - 04:45:42 CST