Msg 159, Level 15, State 1, Line 1
Must specify the table and the index name for DROP INDEX statement.
This error message appears, when you try to issue a DROP INDEX statement without specifying a table- or indexname.
The SQL statement cannot be parsed and further execution is stopped.
Error of the Severity Level 15 are generated by the user and can be fixed by the SQL Server user. You need to provide both the table- and the index name.
All versions of SQL Server.
DROP INDEX Northwind
By definition must both table and index name be provided to sucessfully execute a DROP INDEX statement