Cascade delete

From: Steven <koh_cc_at_pacific.net.sg>
Date: Tue, 08 Dec 1998 17:16:01 -0800
Message-ID: <366DCF51.56F0AF7C@pacific.net.sg>

hi,

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.sg

--

With regards
Steven

Steven Koh, Internet Software Engineer, Mediaworks, Pacific Internet Pte. Ltd., 77 Science Park Drive, 04-09/12
Cintech III, Singapore Science Park,
Singapore 118256.

Tel: (65) 7711305;
Fax: (65) 8728523
www.mediaworks.com.sg, www.pacific.net.sg Received on Tue Dec 08 1998 - 19:16:01 CST