DROP TABLESPACE v17
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;