DROP INDEX Statement

Deletes an index from an SQL table.

Syntax

DROP INDEX index-name

Syntax Elements

index-name =
index-qualifier.index-identifier

index-qualifier
the base-table-name.

index-identifier
The name of the required index.

Restrictions

Only the SQL owner of the table can perform this statement. The owner must have SQL Catalog Maintenance privilege set in the Reality security profile

Comments

index-qualifier is required.

Example

DROP INDEX EMP.DEPTIDX