2.15 DROP INDEX

---

Description

Deletes an index on the specified table.

Syntax

DROP INDEX [index_owner_name.]index_name

[ON [table_owner_name.]table_name]

Arguments

index_owner_name
If index_owner_name is specified and is different from the name of the user executing the statement, then the user must have DBA privileges.

table_name
The table_name argument is optional. If specified, the index_name is verified to correspond to the table.

Example

DROP INDEX custindex ON customer ;

Authorization

The user executing this statement must have any of the following privileges:

DBA privilege
Ownership of the index

SQL Compliance	ODBC Core SQL grammar
Environment	Embedded SQL, interactive SQL, ODBC applications
Related Statements	CREATE INDEX, ALTER INDEX