Propriété 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.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

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

Valeur de propriété

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

Notes

[!REMARQUE]

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

Exemples

Création, modification et suppression d'index

Voir aussi

Référence

Index Classe

Espace de noms Microsoft.SqlServer.Management.Smo

Autres ressources

Index

CREATE INDEX (Transact-SQL)