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.
Examples
Creating, Altering, and Removing Indexes
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace