Hi, sample database is:
PRAGMA FOREIGN_KEYS=1; CREATE TABLE cat(id INTEGER PRIMARY KEY, name); INSERT INTO cat VALUES (1, 'Alice'); CREATE TABLE owner(pet INTEGER REFERENCES cat(id)); INSERT INTO owner VALUES(1); This script fails to drop tables with 'foreign key constraint failed': SAVEPOINT edit; PRAGMA FOREIGN_KEYS=0; DROP TABLE cat; DROP TABLE owner; RELEASE edit; PRAGMA FOREIGN_KEYS=1; This script works OK: PRAGMA FOREIGN_KEYS=0; DROP TABLE cat; DROP TABLE owner; PRAGMA FOREIGN_KEYS=1; Why? -- Григорий Григоренко _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
