Developers delete an index when they found that the Index hinders overall performance of INSERT, UPDATE, and DELETE clauses or if they no longer need it. When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to delete 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 indexes they want to delete and click Design (Modify in SP1 or earlier).

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

3. In the Indexes/Keys dialog box, select the index they want to delete.

4. Click Delete.

The index is deleted from the database when they save their table.