Re: help CASCADE across tables

From: Xuening Sun <ba503_at_torfree.net>
Date: Fri, 17 Dec 1999 00:59:34 GMT
Message-ID: <FMv1FB.BAL.0.bloor@torfree.net>

ZC,

You can code your cascading delete triggers or re-create foreign key constraints like "ALTER TABLE referencing_table_name ADD CONSTRAINT FOREIGN KEY (id1, id2 ...) REFERENCES referenced_table_name (r_id1, r_id2 ...) ON DELETE CASCADE; Lorne Sun

Zuin (zuin_chn_at_my-deja.com) wrote:
: 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 - 18:59:34 CST