drop_index man page on Solaris

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

DROP INDEX()			 SQL Commands			  DROP INDEX()

NAME
       DROP INDEX - remove an index

SYNOPSIS
       DROP INDEX 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
       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	  2009-12-09			  DROP INDEX()
[top]

List of man pages available for Solaris

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