Databases - Practical PostgreSQL
Previous Page	Home	Next Page

DROP INDEX

Name

DROP INDEX -- Removes an index from a database.

DROP INDEX 
index_name
 [, ...]

DROP: The message returned if the index is removed successfully.
ERROR: index " index_name " does not exist: The error returned if the specified index cannot be found within the database.

The owner of an index may remove it from the database by using this command.

The following example drops an index called customer_id_idx from the booktown database:

booktown=# 
DROP INDEX customer_id_idx;

DROP

The next example drops two indices simultaneously from the booktown database:

booktown=# 
DROP INDEX books_id_pkey, books_title_idx;

DROP

Databases - Practical PostgreSQL
Previous Page	Home	Next Page