Removes an index.
DROP INDEX [IF EXISTS] <name> [, ...] [CASCADE | RESTRICT]
DROP INDEX
drops an existing index from the database system. To execute this command you must be the owner of the index.
Remove the index title_idx
:
DROP INDEX title_idx;
DROP INDEX
is a Greenplum Database language extension. There are no provisions for indexes in the SQL standard.
ALTER INDEX, CREATE INDEX, REINDEX
Parent topic: SQL Command Reference