> On Dec 19, 2019, at 4:49 PM, Mike Bentley <bent...@crenelle.com> wrote: > > Is it true that "Each index name must be unique in the database"?
Yes. You're right that the docs don't seem to spell this out, but since the syntax to delete an index is "DROP INDEX <indexname>", you couldn't have multiple indexes with the same name because it wouldn't know which one to delete. You can pretty easily get a unique index name by prefixing the name of the table. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users