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