T-SQL Tutorial

Msg 159 Level 15 - Must specify the table name and index name


On Transact SQL language the Msg 159 Level 15 - Must specify the table name and index name for the DROP INDEX statement.

Msg 159 Level 15 Example:

Invalid drop index:

drop index test_idx_1

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

Correct drop index:

drop index test_idx_1 ON test_table

Message
Command(s) completed successfully.

Other error messages: