Database Name

The SQLite database Database Engine tracks the databases opened on a database connection by internal names. The main database file opened on a connection has the name "main" and the name "temp" refers to the database used for temporary tables. However, SQLite also has the concept of attaching another database file to the current database connection. Attaching a database uses a SQL statement with the format of ATTACH DATABASE expr AS database-name. The expression after the AS keyword is the name used internally by the database engine for the attached database.

Many of the ooSQLite methods and functions have as an argument the database name. In these methods and functions, the name refers to the internal name used by SQLite, not the file name of the database. This documentation attempts to distinguish between a database file name and the internal database name by always using file name when refering to the actual database file.