DROP INDEX
Removes an index.
Synopsis
DROP INDEX [ CONCURRENTLY ] [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]Description
DROP INDEX drops an existing index from the database system.
To run this command, you must be the owner of the index.
Parameters
| Parameter | Description |
|---|---|
CONCURRENTLY |
Drop the index without blocking concurrent selects, inserts, updates, and deletes on the index’s table.
A normal NOTE
There are several caveats to be aware of when using this option.
Only one index name can be specified, and the |
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 existing index |
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
Remove the title_idx index:
DROP INDEX title_idx;Remove two indexes:
DROP INDEX title_idx, director_idx;Compatibility
DROP INDEX is a Greengage DB language extension.
There are no provisions for indexes in the SQL standard.