SQL Server Transact Basic to Expert - Disable an index in a table

SQL Server Transact Basic to Expert - Disable an index in a table

This blog show how to disable an index in a table using Alter command

Syntax:

ALTER INDEX index_name ON
table_or_view_name DISABLE


Example:

ALTER INDEX emppkind ON
emptable DISABLE