Re: cascading deletes in OnLine 6

Posted in 1994

Andrey Yu. Grachyov — Thu, 13 Oct 1994 10:07:21 +0300 — source: Informix-list mailing list archive (1991-1998)

Hi, > Can anyone tell me how, in OnLine 6, cascading deletes (and updates ?) are > specified as part of a constraintdefinition in a CREATE TABLE (and perhaps > also ALTER TABLE) instruction. I'm interested in the EXACT syntax. ... REFERENCES <tbl-name> [(col-name, ...)] ON DELETE CASCADE .... Example: ALTER TABLE catalog ADD CONSTRAINT (FOREIGN KEY (stock_num, manu_code) REFERENCES stock ON DELETE CASCADE CONSTRAINT ab) See Informix Guide To SQL, Syntax, Version 6.0 p. 1.21 Bye. --------------------------------------------------------------- Andrew Yu. Grachyov | Phone +7 (095) 928-6078 TERN, Moscow, Russia | +7 (095) 925-1785 andy@tern.msk.su | Fax +7 (095) 280-3870