Renaming an Index

You can rename an index as long as index names are unique within the table. For example, two tables can have an index named XPK_1, but the same table cannot have two indexes named XPK_1. Renaming an index changes only the name of the index; the index is not rebuilt.

Note  When you create a PRIMARY KEY or UNIQUE constraint on a table, an index with the same name as the constraint is automatically created for the table. Because index names must be unique for a table, you cannot create or rename an index to have the same name as the PRIMARY KEY or UNIQUE constraint for the table.

To rename an index

Transact-SQL

Enterprise Manager

SQL-DMO

To modify an index

Enterprise Manager

See Also

Creating an Index