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