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:
- There are more columns in the INSERT statement than values specified in the VALUES clause
- Must declare the scalar variable
- The definition for column must include a data type
- Is not a recognized built-in function name
- Invalid column name
- Operand type clash: int is incompatible with date
- Invalid object name