Modifying Indexes, CALC Keys, and Referential Constraints › Maintaining Indexes › Dropping an Index

Dropping an Index

To drop an index from an existing table, use the SQL DDL DROP INDEX statement.

Considerations

A unique index or CALC key is required on all referenced columns in a constraint, and an index including the referencing (foreign key) columns or a CALC key on all referencing columns must exist to support unlinked constraints. If dropping an index would violate either of these rules, the DROP will not be allowed.

Example

In the following example, an optional index is dropped from a table:

drop index be_lname from emp.benefits;