SQLite – DETACH Database

SQLite DETACH DATABASE statement is used to detach and dissociate a named database from a database connection which was previously attached using ATTACH statement. If the same database file has been attached with multiple aliases, then DETACH command will disconnect only the given name and rest of the attachment will still continue. You cannot detach the main or temp databases.

If the database is an in-memory or temporary database, the database will be destroyed and the contents will be lost.

Syntax

Following is the basic syntax of SQLite DETACH DATABASE ‘Alias-Name’ statement.

DETACH DATABASE 'Alias-Name';

Here, ‘Alias-Name’ is the same alias, which you had used while attaching the database using ATTACH statement.

Example

Consider you have a database, which you created in the previous chapter and attached it with ‘test’ and ‘currentDB’ as we can see using .database command.

sqlite>.databases
seq  name             file
---  ---------------  ----------------------
0    main             /home/sqlite/testDB.db
2    test             /home/sqlite/testDB.db
3    currentDB        /home/sqlite/testDB.db

Let’s try to detach ‘currentDB’ from testDB.db using the following command.

sqlite> DETACH DATABASE 'currentDB';

Now, if you will check the current attachment, you will find that testDB.db is still connected with ‘test’ and ‘main’.

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

Leave a Reply