19.3 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;
Related Topics
Parent topic: SQL Statements for Indexing Spatial Data