ALTER INDEX
Use ALTER INDEX to:
- Rename an index.
Syntax
Rename
To rename an index:
ALTER INDEX <name> RENAME TO <new_name>;
| Syntax element | Description |
|---|---|
<name> |
The current name of the index you want to alter. |
<new_name> |
The new name of the index. |
See also Renaming restrictions.
Privileges
The privileges required to execute this statement are:
- Ownership of the index.