I am executing
DROP INDEX [IX_Users] ON [Users]
and i get a syntax error
what is the exact syntax to DROP an INDEX for MS SQL 2000
thank youDROP INDEX [Users].[IX_Users]
i always check BOL before i post a question here.|||thank you
a really strange syntax not at all like CREATE INDEX|||actually the syntax that Sean gave you is deprecated in 2005, although it still works. It will likely go away with katmai.
in 2005, the preferred syntax is what you tried initially. See:
http://msdn2.microsoft.com/en-us/library/ms176118.aspx
No comments:
Post a Comment