RENAME INDEX statement

The RENAME INDEX statement renames an index in the current schema, which can be any schema except the schema SYS.

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