DROP TABLESPACE

Delete the tablespace.

Summary

DROP TABLESPACE [IF EXISTS] tablespacename

describe

DROP TABLESPACE Deletes tablespace from the system.

Tablespaces can only be deleted by their owner or superuser. All database objects in the tablespace must be empty before deleting the tablespace. Even if no objects in the current database are using the tablespace, objects in other databases may still reside in the tablespace.

Parameters

IF EXISTS

If the tablespace does not exist, please do not report an error. In this case, a notification will be issued.

tablespacename

The name of the tablespace to be deleted.

Example

Delete tablespace mystuff:

DROP TABLESPACE mystuff;

compatibility