Index.IsDisabled Property

 

Gets or sets the Boolean property value that specifies whether the index is disabled.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase)]
public bool IsDisabled { get; }

Property Value

Type: System.Boolean

A Boolean value that specifies whether the index is disabled.

If True, the index is disabled. Otherwise, False (default).

System_CAPS_noteNote

For indexes based on the UserDefinedTableType object the value of IsDisabled is provided by sys.indexes and the value of IsDisabled property is ignored.

Return to top
Show: