Table.OnlineHeapOperation Propiedad

Gets or sets the Boolean value that determines whether the table supports online heap or index operations.

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

Sintaxis

'Declaración
Public Property OnlineHeapOperation As Boolean 
    Get 
    Set
'Uso
Dim instance As Table 
Dim value As Boolean 

value = instance.OnlineHeapOperation

instance.OnlineHeapOperation = value

public bool OnlineHeapOperation { get; set; }

public:
property bool OnlineHeapOperation {
    bool get ();
    void set (bool value);
}

member OnlineHeapOperation : bool with get, set

function get OnlineHeapOperation () : boolean 
function set OnlineHeapOperation (value : boolean)

Valor de la propiedad

Tipo: System.Boolean
A Boolean value that specifies whether the table supports online heap or index operations.If True, the table supports online heap operations. Otherwise, False.

Ejemplos

The following code example lists all of the tables in the AdventureWorks2012 database that support online heap operations.

C#

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

foreach (Table tb in db.Tables) 
{
   if (tb.OnlineHeapOperation == True)
   {
      Console.WriteLine("The " + tb.Name + " table supports online heap operations.");
   }
}

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

Foreach ($tb in $db.Tables) 
{
   If ($tb.OnlineHeapOperation -eq $TRUE)
   {
      Write-Host "The" $tb.Name "table supports online heap operations."
   }
}

Vea también

Referencia

Table Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

Tablas

CREATE TABLE (Transact-SQL)