Removes an index from a database. Available in
gpre, DSQL, and
DROP INDEX name;
Name of an existing index
DROP INDEX removes a user-defined index from a database.
An index can be dropped by its creator, the
SYSDBA user, or any user with operating system root privileges.
An index in use is not dropped until it is no longer in use.
Example: The following
isql statement deletes an index:
DROP INDEX MINSALX;