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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
