Re: help CASCADE across tables
Date: Thu, 16 Dec 1999 14:52:08 +0300
Message-ID: <83ajoj$5j2$1_at_news.rinet.ru>
Hi!
I'm not sure I understood the part about "child diagram", but you can use ON
DELETE CASCADE clause in your ALTER TABLE ADD CONSTRAINT command (Oracle 7.3
or higher, if i'm not wrong). See Oracle documentation on this command.
If your are using Designer/2000, you can set appropriate property (it seems
that it is "Cascade Rules/Delete") of the foreign key you're working with.
Eugene.
Zuin <zuin_chn_at_my-deja.com> wrote in message
news:839cho$toi$1_at_nnrp1.deja.com...
> I'm a performing a delete of a table, which has a child table. Is there
> a way to cascade to the child diagram or vice vera without having to
> change constraints on tables?
> If there is, please provied an example using x, y variables.
>
>
>
>
> Any help anyone can give me is greatful.
>
>
> thanks
> ZC
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 16 1999 - 12:52:08 CET