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:

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

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.