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 indexName TO newIndexName

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.

Parent topic: RENAME statements
Related reference
RENAME COLUMN statement
RENAME TABLE statement