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?
Christian Isberner
Software Consultant