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 could not have two indexes named XPK_1. Renaming an index only changes 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

         

To modify an index

See Also

Creating an Index

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.