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, 1783🔥, 0💬
Popular Posts:
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...