Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Removes a dbspace from the database.
DROP DBSPACE dbspace-name
You must drop all tables in the dbspace before dropping the dbspace. You cannot use the DROP DBSPACE statement to drop the
predefined dbspaces SYSTEM, TEMPORARY, TEMP, TRANSLOG, or TRANSLOGMIRROR.
DROP DBSPACE is prevented whenever the statement affects an object that is currently being used by another connection.
You must be the only connection to the database to execute this statement.
You must have the MANAGE ANY DBSPACE system privilege.
Automatic commit, and causes an implicit checkpoint. Clears the Results tab in the Results pane in Interactive SQL.
This example drops a fictitious dbspace, MyDBSpace, from the database.
DROP DBSPACE MyDBSpace;