New indexes are automatically given system-defined names based on the database table name. If Developers create multiple indexes on a table, the index names are appended with “_1,” “_2,” etc. They can rename an index as long as index names are unique within the table. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to rename an index, they should follow the next steps:

1. In Object Explorer, right-click the table with the index they want to rename and click Design (Modify in SP1 or earlier).

2. From the Table Designer menu, click Indexes/Keys.

3. Select the index from the Selected Primary/Unique Key or Index list.

4. In the grid, click Name and type a new name into the text box.

Their changes are saved to the database when they save the table.