Index.OnlineIndexOperation-Eigenschaft
Gets or sets the Boolean property value that specifies whether the index will be kept online during index operations thus allowing access to the data.
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 Property OnlineIndexOperation As Boolean
Get
Set
'Usage
Dim instance As Index
Dim value As Boolean
value = instance.OnlineIndexOperation
instance.OnlineIndexOperation = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public bool OnlineIndexOperation { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool OnlineIndexOperation {
bool get ();
void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member OnlineIndexOperation : bool with get, set
function get OnlineIndexOperation () : boolean
function set OnlineIndexOperation (value : boolean)
Eigenschaftswert
Typ: System.Boolean
A Boolean value that specifies whether the index will be kept online during index operations.If True, the index will be kept online during index operations. Otherwise, False (default).
Hinweise
.gif "Hinweis") Hinweis |
|---|
For indexes based on the UserDefinedTableType object the value of the OnlineIndexOperation property is always false. |
Beispiele
Erstellen, Ändern und Löschen von Indizes
Siehe auch
Verweis
Microsoft.SqlServer.Management.Smo-Namespace