• Article

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)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property IsDisabled As Boolean
    Get
'Usage
Dim instance As Index
Dim value As Boolean

value = instance.IsDisabled

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

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

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member IsDisabled : bool

function get IsDisabled () : boolean

Property Value

Type: System.Boolean
A Boolean value that specifies whether the index is disabled.
If True, the index is disabled. Otherwise, False (default).

Remarks

Note

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