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.

Learn how to drop an index in SQL Server using T-SQL or SSMS, what to consider before dropping an index, and how to monitor the effects on your database. Skip to main content LinkedIn.

DROP TABLE SalesHistory; GO. CREATE TABLE [dbo].[SalesHistory] ... SQL Server 2008’s table parameter feature is a huge step forward in terms of development and potentially performance.