Alter Index Purpose The Alter Index statement changes the name of an existing index. Index names must not conflict with other user-defined or system-defined names. Syntax ALTER INDEX index_name RENAME TO new_name where: index_name Specifies an existing index name. new_name Specifies the new index name.