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