Additional SQLite database

Imagine a situation, when there is more than one database at the same time is available, you want to use any of them. The SQLiteATTACH DTABASE statement is used to select a specific database, use this command after all SQLite statement will be executed in the attached database.

grammar

The basic syntax of SQLite ATTACH DATABASE statement is as follows:

ATTACH DATABASE 'DatabaseName' As 'Alias-Name';

If the database has not been created, the above command will create a database if the database already exists, put the database file name and the logical database 'Alias-Name' to bind together.

Examples

If you want to attach to an existing databasetestDB.db, the ATTACH DATABASE statement is as follows:

sqlite> ATTACH DATABASE 'testDB.db' as 'TEST';

UseSQLite .database command to display the additional database.

sqlite> .database
seq name file
--- --------------- ----------------------
0 main /home/sqlite/testDB.db
2 test /home/sqlite/testDB.db

Main and tempdatabase name is reserved for the primary database and the database stores temporary tables and other temporary data objects. These two databases are available for each database connection name, and should not be used for additional, or they will get a warning message, as follows:

sqlite> ATTACH DATABASE 'testDB.db' as 'TEMP';
Error: database TEMP is already in use
sqlite> ATTACH DATABASE 'testDB.db' as 'main';
Error: database TEMP is already in use