Collections:
DROP_EXISTING - Recreating an Existing Index in SQL Server
How To Recreate an Existing Index in SQL Server?
✍: FYIcenter.com
If you want to change the definition of an existing index, you can use the "DROP INDEX" statement to drop the index first. Then use the "CREATE INDEX" statement to create it again with the new definition.
But you can also combine those two statements into one:
CREATE INDEX ... WITH (DROP_EXISTING = ON)
The tutorial exercise below recreates fyi_links_url with a change to index columns:
USE FyiCenterData; GO CREATE INDEX fyi_links_url ON fyi_links_indexed (url, counts) WITH (DROP_EXISTING = ON); GO SP_HELP fyi_links_indexed; GO index_name index_description index_keys ---------------- -------------------------------- ------------ fyi_links_counts nonclustered located on PRIMARY counts fyi_links_url nonclustered located on PRIMARY url, counts
⇒ Understanding and Managing Views in SQL Server
⇐ Rebuilding All Indexes on One Table in SQL Server
2016-11-08, 2752🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...