I am trying to remove a combo index by script. When removing a single index key, we usually do this:

DROP INDEX [Reply.NoMember]

...where Reply is the table and NoMember is the field.

But, when using a combo index, our index is combined with multiple keys. So, doing this will not work:

DROP INDEX [Reply.ReplyNoMember]

...assuming the table Reply has a combo index named ReplyNoMember.

How to remove it by script?