The documentation says :Tables in an attached database can be referred
to using the syntax schema-name.table-name. If the name of the table is
unique across all attached databases and the main and temp databases,
then the schema-name prefix is not required. If two or more tables in
different databases have the same name and the schema-name prefix is not
used on a table reference, then the table chosen is the one in the
database that was least recently attached.
I would like to suggest a different default behavior (potentially as an
option): "when the schema-name prefix is not used, then *all* the tables
are accessed, potentially with a qualifier for distinctiveness."
This allows to write a simpler application code, independent of the
actual collection of bases involved.
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel
antivirus Avast.
https://www.avast.com/antivirus
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
