You can drop indexes by using T-SQL or via tools in the SSMS. To drop indexes with T-SQL, you use the
DROP INDEX command, a simple example of which follows:
DROP INDEX [IX_WorkOrder_ScrapReasonID] ON [Production].[WorkOrder]
This command drops the index named
IX_WorkOrder_ScrapReasonID on the
Using the Object Explorer in SSMS is the simplest alternative for dropping indexes. In the Object Explorer, you simply right-click the index you want to drop and then select Delete. The same execution options available for adding and modifying indexes are also available after you select Delete. This includes the option to script the T-SQL statements like that shown in the preceding ...