Cascade delete
From: Steven <koh_cc_at_pacific.net.sg>
Date: Tue, 08 Dec 1998 17:15:27 -0800
Message-ID: <366DCF2F.3DB7E69C_at_pacific.net.sg>
hi,
Date: Tue, 08 Dec 1998 17:15:27 -0800
Message-ID: <366DCF2F.3DB7E69C_at_pacific.net.sg>
hi,
[Quoted] Can anyone advise on how to delete the master and detail table using
"Cascade" SQL command.
Table a : Parent table
Table b : Child table
l've tried : delete from a where a_id=1 cascade.
-- With regards Steven Steven Koh, Internet Software Engineer, www.mediaworks.com.sg, www.pacific.net.sgReceived on Wed Dec 09 1998 - 02:15:27 CET