MSSQL - Fix Error - Must specify the table name and index name for the DROP INDEX statement.

Msg 159, Level 15, State 1, Line 1
Must specify the table name and index name for the DROP INDEX statement.


Watch this example on YouTube



To fix it replace

Drop Index IX_IndexTest
GO

with

Drop TABLE_NAME.Index IX_IndexTest
GO