Proprietà Index.OnlineIndexOperation

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.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public Property OnlineIndexOperation As Boolean 
    Get 
    Set
'Utilizzo
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)

Valore proprietà

Tipo: 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).

Osservazioni

[!NOTA]

For indexes based on the UserDefinedTableType object the value of the OnlineIndexOperation property is always false.

Esempi

Creazione, modifica e rimozione di indici

Vedere anche

Riferimento

Index Classe

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

Indici

CREATE INDEX (Transact-SQL)