Alter Index
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.
