DETACH DATABASE

Updated: April 19, 2023

Detach a database file from the current connection

Synopsis:

 DETACH [DATABASE] database-name 

Description:

This statement detaches a database file previously attached using the ATTACH DATABASE statement. It is possible to attach the same file multiple times by using different names; detaching one file leaves the others intact.

This statement fails if QDB is in the middle of a transaction.