The SQL command to permanently destroy an existing index from a table is DROP INDEX. Here
is the syntax for DROP INDEX:
DROP INDEX
indexname
[, ...]
In this syntax,
indexname
is the name of the index that you wish to permanently remove. Multiple
indices to drop may be specified, separated by commas.
Example 7-6 drops the upper_title_idx index created
in Example 7-5.
Example 7-6. Dropping an index
booktown=#
DROP INDEX upper_title_idx;
DROP
