Javatpoint Logo
Javatpoint Logo

SQLite Detach Database

The SQLite DETACH DATABASE statement is used to detach the alias-named database from a database connection which was previously attached by using ATTACH statement.

If the same database file has been attached with multiple aliases, then DETACH command will disconnect only given name and rest of the attachment will still continue. Main and temp databases cannot be detached.

Note: The databases within the in-memory or temporary database, will be destroyed completely and content will be lost.


Let's take an example to demonstrate how to detach an attached alias database. Here, we have a attached database "JavaTpoint".

SQLite Detach database 1

Detach 'JavaTpoint' from JTP.db:

SQLite Detach database 2

Database is detached now. You can see it by using ".databases" command.

SQLite Detach database 3

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA