DROP INDEX
SQL - Language Statements
DROP INDEX
Removes an index from a database
1998-04-15
DROP INDEX index_name
1998-04-15
Inputs
index_name
The name of the index to remove.
1998-04-15
Outputs
DROP
The message returned if the index is successfully dropped.
ERROR: index "index_name" nonexistent
This message occurs if it is impossible to drop the index
because it does not exist.
1998-04-15
Description
DROP INDEX drops an existing index from the database
system. To execute this command you must be the owner of
the index.
1998-04-15
Notes
DROP INDEX is a PostgreSQL language extension.
Refer to the CREATE INDEX statement for
inforamtion on how to create indexes.
Usage
This command will remove the title_idx index:
DROP INDEX title_idx;
Compatibility
1998-04-15
SQL92
There is no DROP INDEX statement on SQL92.