Another IT and more specifically a database tutorial on how to drop an index from a table in SQL Server. An index is associated with an existing table in a database. It can be a relational or transactional database.<\/p>\n\n\n\n
For example, learn here why it is important to implement maintenance <\/a>plans to improve performance and management of MS SQL resources.<\/p>\n\n\n\n Firstly, to delete an unnecessary index, simply copy and paste this sample code and adjust it with the index and table names. This code will delete the index created in this article.<\/p>\n\n\n\n It is also possible to delete an index from the SSMS GUI.<\/p>\n\n\n\n This SQL Server command uses the DROP command and the INDEX keyword. The full name of the index and of course the table name follow the DROP INDEX command.<\/p>\n\n\n\n Indeed, an index has a unique name for a given table. Name the indexes with the table prefix. To distinguish them and make it easier to manage the T-SQL code.<\/p>\n\n\n\n In this SQL script, the two tables SALES and SALES_2 have the same index created with the same name.<\/p>\n\n\n\n Secondly, this is the same syntax as most objects deleted with Data Definition Language (DDL) queries.<\/p>\n\n\n\n In addition, please note that after deleting the index, all queries will use the primary key of the SQL table<\/a><\/strong>. This can have a huge impact on performance.<\/p>\n\n\n\nDrop an index in SQL Server with a script (DROP INDEX)<\/h2>\n\n\n\n
It is possible to have the same index name on different SQL Server tables<\/h3>\n\n\n\n
CREATE TABLE [dbo].[SALES]\n(\n [Year] TINYINT,\n [MonthName] NVARCHAR(50),\n [MonthCurrent] BIT,\n [NumberMonth] TINYINT,\n [EmployeeNumber] SMALLINT,\n [NumberOfClients] INTEGER,\n [NumberOfSales] BIGINT,\n [Amount_ET] NUMERIC(15,5),\n [Amount_IT] DECIMAL(15,5)\n);\n\nCREATE INDEX indexYearMonth\nON [dbo].[SALES] ([Year], [MonthName]);\nGO\n\nCREATE TABLE [dbo].[SALES_2]\n(\n [Year] TINYINT,\n [MonthName] NVARCHAR(50),\n [MonthCurrent] BIT,\n [NumberMonth] TINYINT,\n [EmployeeNumber] SMALLINT,\n [NumberOfClients] INTEGER,\n [NumberOfSales] BIGINT,\n [Amount_ET] NUMERIC(15,5),\n [Amount_IT] DECIMAL(15,5)\n);\n\nCREATE INDEX indexYearMonth\nON [dbo].[SALES_2] ([Year], [MonthName]);\nGO<\/pre>\n\n\n\n
Script to delete a MS SQL index from a table<\/h3>\n\n\n\n
DROP INDEX indexYearMonth\n ON [dbo].[SALES] ;\nGO<\/pre>\n\n\n\n