DROP DBSPACE statement

Removes a dbspace from the database.

Syntax

DROP DBSPACE dbspace-name

Remarks

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.

Privileges

You must have the MANAGE ANY DBSPACE system privilege.

Side effects

Automatic commit, and causes an implicit checkpoint.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

This example drops a fictitious dbspace, MyDBSpace, from the database.

DROP DBSPACE MyDBSpace;