共用方式為

  • 發行項

OnlineHeapOperation 屬性

取得或設定 Boolean 值，這個值會決定資料表是否支援線上堆積或索引作業。

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Property OnlineHeapOperation As Boolean
    Get
    Set
'用途
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)

屬性值

型別：System. . :: . .Boolean
Boolean 值，這個值會指定資料表是否支援線上堆積或索引作業。
如果為 True，則表示資料表支援線上堆積作業，否則為 False。

範例

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

C#

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

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("AdventureWorks2008R2")

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