IT Solutions
Search This Blog
Friday, September 28, 2012
How to disable, enable and drop an Index in SQL?
-- Disable Index in table tblUser
ALTER INDEX IX_tblUser ON tblUser DISABLE;
-- Enable Index in table tblUser
ALTER INDEX IX_tblUser ON tblUser REBUILD;
--DROP Index from table tblUser
DROP INDEX IX_tblUser ON tblUser
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment