drop_tablespace man page on UnixWare

Man page or keyword search:  
man Server   3616 pages
apropos Keyword Search (all sections)
Output format
UnixWare logo
[printable version]

DROP TABLESPACE()		 SQL Commands		     DROP TABLESPACE()

NAME
       DROP TABLESPACE - remove a tablespace

SYNOPSIS
       DROP TABLESPACE [ IF EXISTS ] 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
       IF EXISTS
	      Do not throw an error if the tablespace does not exist. A notice
	      is issued in this case.

       tablespacename
	      The name of a tablespace.

NOTES
       DROP TABLESPACE cannot be executed inside a transaction block.

EXAMPLES
       To remove tablespace mystuff from the system:

       DROP TABLESPACE mystuff;

COMPATIBILITY
       DROP TABLESPACE is a PostgreSQL extension.

SEE ALSO
       CREATE	 TABLESPACE    [create_tablespace(5)],	  ALTER	    TABLESPACE
       [alter_tablespace(l)]

SQL - Language Statements	  2008-01-03		     DROP TABLESPACE()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server UnixWare

List of man pages available for UnixWare

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net