ALTER INDEX RENAME TO
Syntax
ALTER INDEX [schema.]index RENAME TO <new_index_name>;
ALTER INDEX [schema.]index PARTITION partition RENAME TO <new_partition_name>;Purpose
Changes the name of a spatial index or a partition of a spatial index.
Keywords and Parameters
| Value | Description |
|---|---|
| new_index_name | Specifies the new name of the index. |
| new_partition_name | Specifies the new name of the partition. |
Prerequisites
-
You must have EXECUTE privileges on the index type and its implementation type.
-
The spatial index to be altered is not marked in-progress.
Usage Notes
None.
Examples
The following example renames OLDINDEX to NEWINDEX.
ALTER INDEX oldindex RENAME TO newindex;