Renames an existing index on a given table.

Syntax

---

RENAME INDEX <Name> ON <TableName>|<ViewName>
TO <Name>

Usage

---

Use this statement to rename an index or text index on a table or non-updateable view.

As of ElevateDB 2.21, you can now index non-updateable views. Non-updateable views are views that generate a static, insensitive result set.

Examples

---

-- The following statement renames the Name
index to CustName.

RENAME INDEX "Name" FROM "Customer"
TO "CustName"

Required Privileges

---

The current user must be granted the ALTER privilege on the specified table in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: