Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.1 ALTER INDEX

ALTER INDEX -- modify an existing index.
Advanced Server supports two variations of the ALTER INDEX command compatible with Oracle databases. Use the first variation to rename an index:
ALTER INDEX name RENAME TO new_name
Use the second variation of the ALTER INDEX command to rebuild an index:
ALTER INDEX name REBUILD
ALTER INDEX changes the definition of an existing index. The RENAME clause changes the name of the index. The REBUILD clause reconstructs an index, replacing the old copy of the index with an updated version based on the index's table.
The REBUILD clause invokes the PostgreSQL REINDEX command; for more information about using the REBUILD clause, see the PostgreSQL core documentation at:
ALTER INDEX has no effect on stored data.
To change the name of an index from name_idx to empname_idx:

2 The SQL Language : 2.3 SQL Commands : 2.3.1 ALTER INDEX

Table of Contents Previous Next