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

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

Index Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Indizes

CREATE INDEX (Transact-SQL)