I wrote: > Roland Wilczek wrote: >> CREATE TABLE track (artist, >> FOREIGN KEY (artist) REFERENCES artist(id) ON DELETE CASCADE >> FOREIGN KEY (artist) REFERENCES artist(id) ON DELETE RESTRICT); > > This particular statement creates a table with a single foreign key > constraint.
Sorry, I was wrong: sqlite> pragma foreign_key_list(track); 0|0|artist|artist|id|NO ACTION|RESTRICT|NONE 1|0|artist|artist|id|NO ACTION|CASCADE|NONE Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users