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?