7:drop tablespace

From Linux Man Pages

      DROP TABLESPACE - remove a tablespace
      
      DROP TABLESPACE tablespacename

Contents 1 DESCRIPTION 2 PARAMETERS 3 EXAMPLES 4 COMPATIBILITY 5 RELATED 6 CATEGORY

DESCRIPTION

      DROP TABLESPACE removes a tablespace from the system.
 
      A  tablespace  can  only  be  dropped  by its owner or a superuser.  The tablespace must be empty of all database
      objects before it can be dropped. It is possible that  objects  in  other  databases  may  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

      To remove tablespace mystuff from the system:
 
      DROP TABLESPACE mystuff;

COMPATIBILITY

      DROP TABLESPACE is a PostgreSQL extension.

RELATED

      CREATE TABLESPACE [[[7:create_tablespace|create_tablespace(7)]]], ALTER TABLESPACE [alter_tablespace(l)]

SQL - Language Statements 2005-11-05 DROP TABLESPACE()

CATEGORY