RENAME INDEX statement 

The RENAME INDEX statement changes the name of an index.

Syntax

<rename index statement> ::= RENAME INDEX <old index name> [ON <table name>] TO <new index name>

<old index name> ::= <index name>
<new index name> ::= <index name>

table name, index name

Explanation

The specified table name must be the name of an existing base table (see table).

The index identified by the old index name must exist. ON <table name> is not necessary if this index is unique.

The current user must be the owner of the specified table or have the INDEX privilege for it.

The new index name must not be identical to an existing index name for the table.