Collections:
DROP INDEX - Removing Existing Indexes in SQL Server
How To Drop Existing Indexes in SQL Server?
✍: FYIcenter.com
For some reason, if you want remove an existing index, you can use the DROP INDEX statement with following syntax:
CREATE INDEX table_name.index_name
The tutorial exercise below shows you how to remove the index "fyi_links_id":
USE FyiCenterData; GO SELECT * FROM sys.indexes WHERE object_id = ( SELECT object_id FROM sys.tables WHERE name = 'fyi_links' ); GO object_id name index_id type_desc is_unique --------- ------------- -------- ---------- --------- 421576540 NULL 0 HEAP 0 421576540 fyi_links_id 2 NONCLUSTERED 0 421576540 fyi_links_url 3 NONCLUSTERED 0 DROP INDEX fyi_links.fyi_links_id; GO SELECT * FROM sys.indexes WHERE object_id = ( SELECT object_id FROM sys.tables WHERE name = 'fyi_links' ); GO object_id name index_id type_desc is_unique --------- ------------- -------- ---------- --------- 421576540 NULL 0 HEAP 0 421576540 fyi_links_url 3 NONCLUSTERED 0
⇒ Primary Key - Default Indexes of Tables in SQL Server
⇐ sys.indexes - Viewing Existing Indexes on an Given Table in SQL Server
2016-11-15, 1345🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...