| title | DROP INDEX Statement | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| helpviewer_keywords |
|
||
| ms.assetid | cd0ff767-9254-413b-bd1a-bed26c6774f5 | ||
| caps.latest.revision | 5 | ||
| author | MightyPen | ||
| ms.author | genemi | ||
| manager | jhubbard |
When the Microsoft Access, dBASE, or Paradox driver is used, the syntax of the DROP INDEX statement is "DROP INDEX a on b" where "a" is the name of the index and "b" is the name of the table (not DROP INDEX index-name).
When the Paradox driver is used, the DROP INDEX statement deletes Paradox secondary index files.
The DROP INDEX statement is not supported for the Microsoft Excel or Text drivers.