The DROP INDEX (drop_index_statement) SQL statement is accepted by SAP MaxDB with the following restriction:

Due to different namespaces existing for indexes, an index is not always uniquely identified in SAP MaxDB by an index name specification. In such a case, the table to which the index refers must be explicitly specified.