>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?

What is the exact error you're getting and what is the script to create it so I can test the same?

Also, your syntax seems to be a bit wrong according to DROP INDEX

DROP INDEX ReplyNoMember ON dbo.Reply