DETACH DATABASE
On this page
Takes an unlimited storage database offline.
The workspace will keep a reference to the database after it is detached.DETACH and ATTACH a database by using its name.
Check here for the permissions required to use this command.
Syntax
DETACH DATABASE remote_
Arguments
milestone_
A quoted string that is the milestone to detach the database at.
Remarks
-
After detaching a database, you can reattach the database using ATTACH DATABASE.
The reattach can be done optionally at a milestone or a point in time, and with the same or a different database name. -
This command cannot be run on system databases.
-
Refer to the Permission Matrix for the required permission.
Example
DETACH DATABASE db AT MILESTONE "m";Detach a Database from a Workspace
To detach a database from a workspace, execute the following command:
DETACH DATABASE db_name FROM WORKSPACE wspace1where wspace1 is the unique name of the workspace in the workspace group.
Last modified: February 23, 2024