Consider: CREATE TABLE a(id INTEGER PRIMARY KEY); CREATE TABLE b(id INTEGER PRIMARY KEY); CREATE TABLE c(id INTEGER PRIMARY KEY, a_id, b_id, FOREIGN KEY (a_id) REFERENCES a(id) FOREIGN KEY (b_id) REFERENCES b(id));
Note the lack of comma between the two foreign key constraints in the definition for table c. The syntax diagrams in the documentation indicate that the comma is mandatory, but not only does this not cause a parse error, but both of them are detected: sqlite> PRAGMA foreign_key_list(c); id seq table from to on_update on_delete match ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- 0 0 b b_id id NO ACTION NO ACTION NONE 1 0 a a_id id NO ACTION NO ACTION NONE _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users