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, 1403🔥, 0💬
Popular Posts:
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...