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?