Hello,

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?