Purpose

Changes the name of an existing index.

Syntax

ALTER INDEX index_name RENAME TO new_name

where:

index_name
specifies an existing index name.
new_name
specifies the new index name.

Notes

  • Index names must not conflict with other user-defined or system-defined names.
  • Indexes on remote tables cannot be created, altered or dropped. Indexes can only be defined on local tables.