Compartir a través de


Index.OnlineIndexOperation Propiedad

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.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

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

Valor de la propiedad

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

Comentarios

[!NOTA]

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

Ejemplos

Crear, modificar y eliminar índices

Vea también

Referencia

Index Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

Índices

CREATE INDEX (Transact-SQL)