Share via

  • Article

Index.OnlineIndexOperation Property

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)

Property Value

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

Remarks

Note

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