Database Object Name Resolution
SQL As Understood By SQLite
Database Object Name Resolution
In SQLite, a database object (a table, index, trigger or view) is identified by the name of the object and the name of the database that it resides in- Database objects may reside in the main database, the temp database, or in an attached database.
The syntax of the DROP TABLE, DROP INDEX, DROP VIEW, DROP TRIGGER, REINDEX, ALTER TABLE and many other commands all permit the user to specify a database object either by its name alone, or by a combination of its name and the name of its database. If no database is specified as part of the o