ALTER INDEX Examples

Deactivating the IDX_UPDATER index
```
ALTER INDEX IDX_UPDATER INACTIVE;
```
Switching the IDX_UPDATER index back to the active state and rebuilding it
```
ALTER INDEX IDX_UPDATER ACTIVE;
```

`DROP INDEX`

Drops an index

Available in

DSQL, ESQL

Syntax

DROP INDEX indexname

Table 1. `DROP INDEX` Statement Parameter
Parameter	Description
indexname	Index name

The DROP INDEX statement drops (deletes) the named index from the database.

Note	A constraint index cannot be dropped using `DROP INDEX`.Constraint indexes are dropped during the process of executing the command `ALTER TABLE … DROP CONSTRAINT …`.