This topic has not yet been rated - Rate this topic

Table.OnlineHeapOperation Property

SQL Server 2012

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 (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

public bool OnlineHeapOperation { get; set; }

Property Value

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

Examples

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

Reference

Table Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tables

CREATE TABLE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD