drop_index man page on OpenServer

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

DROP INDEX()			 SQL Commands			  DROP INDEX()

NAME
       DROP INDEX - remove an index

SYNOPSIS
       DROP INDEX [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION
       DROP INDEX drops an existing index from the database system. To execute
       this command you must be the owner of the index.

PARAMETERS
       IF EXISTS
	      Do not throw an error if the index does not exist. A  notice  is
	      issued in this case.

       name   The name (optionally schema-qualified) of an index to remove.

       CASCADE
	      Automatically drop objects that depend on the index.

       RESTRICT
	      Refuse  to  drop	the index if any objects depend on it. This is
	      the default.

EXAMPLES
       This command will remove the index title_idx:

       DROP INDEX title_idx;

COMPATIBILITY
       DROP INDEX is a PostgreSQL language extension. There are no  provisions
       for indexes in the SQL standard.

SEE ALSO
       CREATE INDEX [create_index(5)]

SQL - Language Statements	  2008-06-08			  DROP INDEX()
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server OpenServer

List of man pages available for OpenServer

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