SQLite - DETACH Database


Advertisements

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

Useful Video Courses

Video

Android SQLite Programming for Beginners

25 Lectures 4.5 hours

Sandip Bhattacharya

Video

Local SQLite Database with Node for beginners

17 Lectures 1 hours

Laurence Svekis

Video

Angular 12, Python Django & SQLite Full Stack Web Development

5 Lectures 51 mins

Vinay Kumar

Advertisements