A user with REFERENCES permissions on the table can execute DROP INDEX.
The DROP INDEX statement cannot be executed when there are cursors opened with the WITH HOLD clause that use either statement
or transaction snapshots.
Automatic commit. Clears the Results tab in the Results pane in Interactive SQL. The DROP INDEX statement closes all cursors for the current connection.
If you use the DROP INDEX statement to drop an index on a local temporary table an error is returned indicating that the index
could not be found. Use the DROP TABLE statement to drop a local temporary table. Indexes on local temporary tables are dropped
automatically when the local temporary table goes out of scope.