>Wait, I don't get an error with another index, I think I looked in a wrong place.
>
>>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?


If the index is PK index you need to drop constraint not index.