Disable Indexes with SQL December 21, 2017 Sometimes you will need to disable an index, albeit temporarily. In order to disable an Index, make use of the following T-SQL Query: USE DatabaseNameGO ALTER INDEX NameOfIndex ON Table.Field