cascade constraint

Commande définition_clé_étrangère
CONSTRAINT nom_sql] FOREIGN KEY (ref_colonne, ... , ref_colonne) REFERENCES nom_sql [(ref_colonne, ... , ref_colonne)] [ON DELETE {RESTRICT | CASCADE}] [ON UPDATE {RESTRICT ...
http://www.4d.fr/documentation/4DdocV11/CMF/CMF18453.HTM

tp2_2002
constraint R1 foreign key(A3) references TABLE2(A3) on delete cascade constraint C1 check(A4 in ('S','T','Q')) constraint SYS_C00390 check(A4 is not null)..
http://www.lifl.fr/~bossut/Docu/tp2_2002.html

Syntaxe
CONSTRAINT constraint] [NOT] NULL | UNIQUE | PRIMARY KEY | REFERENCES [schema.]table [(column)] [ON DELETE CASCADE] | CHECK (condition) [ USING INDEX [PCTFREE integer ...
http://wwwsi.supelec.fr/~yb/poly_bd/node145.html#SECTION03520100000000000000

www.onlamp.com
DROP TABLE mailid CASCADE; DROP TABLE main CASCADE; DROP TABLE mailto CASCADE; ... CONSTRAINT fk_main FOREIGN KEY (messageid) REFERENCES mailid, CONSTRAINT pk_main PRIMARY KEY ...
http://www.onlamp.com/onlamp/2004/04/08/examples/createTables.sql