Commands
ALTER INDEX
The ALTER INDEX
command modifies the definition of an index.
Syntax
alteroption
depends on the operation you want to perform on the index. For all supported clauses, see the sections below.
Clause
RENAME TO
Parameter or clause | Description |
---|---|
RENAME TO | This clause changes the name of the index. If the index is associated with a table constraint (either UNIQUE, PRIMARY KEY, or EXCLUDE), the constraint is renamed as well. There is no effect on the stored data. |
new_name | The new name of the index. |
Was this page helpful?