Previous Next JavaScript must be enabled to correctly display this content

## Using SQL command to drop index

The DROP INDEX removes the specified index from the database.

If an index with the given name does not exist, then the statement fails, and an error is reported. If the optional IF EXISTS clause is used in the DROP INDEX statement, and if an index with the same name does not exist, then the statement will not execute, and no error is reported.

Example: Drop the index `multikeyindex1`.

    DROP INDEX multikeyindex1 ON stream_acct