Using SQL Server Management Studio (SSMS), a graphical user interface (GUI) tool, you can drop an index in SQL Server. To do so, open SSMS and connect to your database server.