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.

Syntax:

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

Detach 'JavaTpoint' from JTP.db:

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