Documentation → PostgreSQL 8.0

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

Historical version. PostgreSQL 8.0 reached end of support in October 2010. See the current version for supported releases.

PostgreSQL 8.0.26 Documentation
Prev	Fast Backward		Fast Forward	Next

DROP INDEX

Name

DROP INDEX -- remove an index

DROP INDEX 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.

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.

This command will remove the index title_idx:

DROP INDEX title_idx;

DROP INDEX is a PostgreSQL language extension. There are no provisions for indexes in the SQL standard.

Read the upstream documentation. For corrections, first check the current version.

Prev	Home	Next
DROP GROUP	Up	DROP LANGUAGE