Propriedade do RDL Table.OnlineHeapOperation

Artigo
04/26/2013

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

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
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 da propriedade

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.

Exemplos

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

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."
   }
}

Consulte também

Referência

Table Classe

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Tabelas

CREATE TABLE (Transact-SQL)

Partilhar via