Each SQLite file will be its own database with its own tables and indexes. So for each database you just define an index on the appropriate tables.
I'm not sure why you want multiple files, but it's fine. You can always have one master db from which you ATTACH the others as needed. You just can't have 1 index that spans multiple files, or do foreign key checks between files, etc. https://www.sqlite.org/lang_attach.html -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of John R. Sowden Sent: Thursday, August 02, 2018 1:12 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Common index for multiple databases I have been reviewing sqlite for a couple of years, but still use foxpro. I have a question regarding an index issue. Currently I have several types of databases (in foxpro, one per file) that all point to an index of a common field, a customer account number. The databases are for accounting, technical, general info lookup, etc. \ I do not want these databases to all reside in one sqlite file. How do I index each database on this customer account number when each database and associated index are in separate files? Is this what seems to be referred to as an external file? I assume that I would have to reindex each database each time it is opened, since a record could have been edited, etc. tia, John _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
