Index.IsDisabled-Eigenschaft
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
Eigenschaftswert
Typ: System.Boolean
A Boolean value that specifies whether the index is disabled.If True, the index is disabled. Otherwise, False (default).
Hinweise
.gif "Hinweis") Hinweis |
|---|
For indexes based on the UserDefinedTableType object the value of IsDisabled is provided by sys.indexes and the value of IsDisabled property is ignored. |
Beispiele
Erstellen, Ändern und Löschen von Indizes
Siehe auch
Verweis
Microsoft.SqlServer.Management.Smo-Namespace