DETACH DATABASE
The DETACH DATABASE statement removes a previously attached database from the current connection. After detaching, tables in that database are no longer accessible through the schema name.Syntax
Description
DETACH closes the connection to the attached database identified byschema-name and frees its resources. Any subsequent references to schema-name.table-name will fail.
Clauses
The
main and temp schemas cannot be detached.
DETACH cannot be used while a transaction is active. Commit or roll back any open transaction before detaching a database.
Examples
Detach a Database
Detach Without the DATABASE Keyword
See Also
- ATTACH DATABASE for attaching a database