DROP Statement Example

The following examples assume the existence of a hypothetical NewIndex index on the Employees table in the Northwind database. This example deletes the index MyIndex from the Employees table.

DROP INDEX NewIndex ON Employees;

This example deletes the Employees table from the database.

DROP TABLE Employees;