發行項
04/02/2012

IsPartitioned 屬性

取得 Boolean 屬性值，指定資料表是否已分割。

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

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property IsPartitioned As Boolean
    Get
'用途
Dim instance As Table
Dim value As Boolean

value = instance.IsPartitioned

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool IsPartitioned { get; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool IsPartitioned {
    bool get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member IsPartitioned : bool

function get IsPartitioned () : boolean

屬性值

型別：System. . :: . .Boolean
Boolean 值，這個值會指定資料表是否已分割。
如果為 True，則表示資料表已分割，否則為 False (預設值)。

備註

Partitioning is used to increase performance.

範例

The following code example shows how to list all of the partitioned tables in the AdventureWorks2008R2 database.

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

foreach (Table tb in db.Tables) 
{
   if (tb.IsPartitioned == True)
   {
      Console.WriteLine("The " + tb.Name + " table is paritioned.");
   }
}

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.IsPartitioned -eq $TRUE)
   {
      Write-Host "The" $tb.Name "table is partitioned."
   }
}