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