I logon with SA account, and the index does exist.

DROP INDEX MyIndex ON MyTable:
Cannot drop index because it doesn't exist or you don't have permission

ALTER TABLE MyTable DROP INDEX MyIndex
Incorrect syntax near 'index'. If this is intended as part of a table hint, A WITH keyword and parenthesis are now required.

I am completely lost.

>What kind of index is it? What error do you get?
>
>>I figured that out, but I can't drop the index with the two commands I mentioned below. How can I drop the index?
>>
>>
>>>You have to drop index first.
>>>
>>>>
>>>>I can't figure out how to drop a field that has an index in SQL Server?
>>>>when I try DROP INDEX myIndex ON MyTable it gives me an error, but also when I type ALTER TABLE MyTable DROP INDEX MyIndex.
>>>>What is the correct syntax?