RENAME INDEX statement

This statement allows you to rename an index in the current schema. Users cannot rename indexes in the SYS schema.

Syntax

RENAME INDEX index-Name TO new-index-Name

Example

RENAME INDEX DESTINDEX TO ARRIVALINDEX

Statement dependency system

RENAME INDEX is not allowed if there are any open cursors that reference the index being renamed.

Related reference
RENAME COLUMN statement
RENAME TABLE statement