Renaming an Index

Creating and Maintaining Databases

Creating and Maintaining Databases

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