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

Karthikeyan Anbarasan
13y
3.2k
0
0

Blog

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

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

Up Next

SQL Server Transact Basic to Expert - To See index metadata

Ebook Download

View all

Basics of SQL Server

Read by 1.5k people

Download Now!

Learn

View all