DROP TABLESPACE v16

Name

DROP TABLESPACE  Remove a tablespace.

Synopsis

DROP TABLESPACE <tablespacename>

Description

DROP TABLESPACE removes a tablespace from the system.

Only a superuser or the tablespace owner can drop a tablespace. The tablespace must be empty of all database objects before you drop it. Objects in other databases might still reside in the tablespace even if no objects in the current database are using the tablespace.

Parameters

tablespacename

The name of a tablespace.

Examples

This example removes the tablespace employee_space from the system:

DROP TABLESPACE employee_space;

See also

ALTER TABLESPACE