DROP TABLESPACE() SQL Commands DROP TABLESPACE() NAME DROP TABLESPACE - remove a tablespace SYNOPSIS DROP TABLESPACE tablespacename 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. SEE ALSO CREATE TABLESPACE [create_tablespace(7)], ALTER TABLESPACE [alter_tablespace(l)] SQL - Language Statements 2008-01-03 DROP TABLESPACE()[top]
Vote for polarhome |