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

Reply via email to