DROP_INDEX(l)                                       DROP_INDEX(l)

NAME
       DROP INDEX - Removes an index from a database

SYNOPSIS
       DROP INDEX index_name

   INPUTS
       index_name
              The name of the index to remove.

   OUTPUTS
       DROP   The  message  returned if the index is successfully
              dropped.

       ERROR: index "index_name" nonexistent
              This message occurs if index_name is not  an  index
              in the database.

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

   NOTES
       DROP INDEX is a Postgres language extension.

       Refer  to create_index(l) for information on how to create
       indexes.

USAGE
       This command will remove the title_idx index:

           DROP INDEX title_idx;

COMPATIBILITY
   SQL92
       SQL92 defines commands by which to access a generic  rela-
       tional  database.  Indexes are an implementation-dependent
       feature and hence there are no index-specific commands  or
       definitions in the SQL92 language.

SQL - Language Statements 15 August 1999                        1