1.9.1. Grammar ¶

The basic syntax of the DETACH DATABASE ‘Alias-Name’ statement for SQLite is as follows:

DETACH DATABASE 'Alias-Name';

Here, ‘Alias-Name’ is the same alias you used to attach the database using the ATTACH statement.

1.9.2. Example ¶

Assuming that you have created a database in the previous section and attached the ‘test’ and’ currentDB’, using .database commands, we can see:

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

Now, let’s try to separate ‘currentDB’ from the testDB.db, as follows:

sqlite> DETACH DATABASE 'currentDB';

Now, if you check the currently attached database, you will find that testDB.db is still connected to ‘test’ and’ main’.

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