Drop Index Tool

The Drop Index Tool allows users select an index to be dropped. The tool then generates the SQL to drop the index.

Listed below is an example SQL statement generated by the Drop Index Tool.

DROP INDEX public.it_index1

The following are links to information about the Drop Index tool for specific databases:

DB2 Drop Index
Derby Drop Index
Firebird Drop Index
HSQLDB Drop Index
Informix Drop Index
Ingres Drop Index
MySQL Drop Index
Oracle Drop Index
PostgreSQL Drop Index
MS SQL Server Drop Index
SQLite Drop Index
SQL Anywhere Drop Index
Sybase Drop Index