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. See Predefined dbspaces.

DROP DBSPACE is prevented whenever the statement affects an object that is currently being used by another connection.

You must own the object, or have DBA authority, and be the only connection to the database.

Automatic commit, and causes an implicit checkpoint. Clears the Results tab in the Results pane in Interactive SQL.

• CREATE DBSPACE statement
• ALTER DBSPACE statement
• Delete a dbspace

Drop MyDBSpace from the database. If the dbspace does not exist, an error is returned.

DROP DBSPACE MyDBSpace;