Looking at the documentation for the latest version I think I understand that I must define indexes for all foreign keys, manually, with UNIQUE as described in the documentation. If I don't then the database will give me an immediate or deferred error. These Foreign Key indexes are NOT generated automatically by the database when I define a FOREIGN KEY... REFERENCES... ON DELETE.. constraint. I want to double check before I screw up my (sizable) database. I seem to remember that most DBMS (eg Oracle) would create these indexes automatically. Thank you!
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users