IsPartitioned-Eigenschaft
Ruft den Boolean-Eigenschaftswert ab, der angibt, ob die Tabelle partitioniert ist.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property IsPartitioned As Boolean
Get
'Usage
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
Eigenschaftswert
Typ: System. . :: . .Boolean
Ein Boolean-Wert, der angibt, ob die Tabelle partitioniert ist.
True gibt an, dass die Tabelle partitioniert ist. Der Standardwert ist allerdings False.
Hinweise
Partitioning is used to increase performance.
Beispiele
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."
}
}
Siehe auch