Table.PhysicalPartitions 属性
Gets the physical partitions in which the table data is stored.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, GetType(PhysicalPartition))> _
Public ReadOnly Property PhysicalPartitions As PhysicalPartitionCollection
Get
用法
Dim instance As Table
Dim value As PhysicalPartitionCollection
value = instance.PhysicalPartitions
[SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, typeof(PhysicalPartition))]
public PhysicalPartitionCollection PhysicalPartitions { get; }
[SfcObjectAttribute(SfcContainerRelationship::ChildContainer, SfcContainerCardinality::OneToAny,
typeof(PhysicalPartition))]
public:
property PhysicalPartitionCollection^ PhysicalPartitions {
PhysicalPartitionCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny,
typeof(PhysicalPartition))>]
member PhysicalPartitions : PhysicalPartitionCollection
function get PhysicalPartitions () : PhysicalPartitionCollection
属性值
类型:Microsoft.SqlServer.Management.Smo.PhysicalPartitionCollection
A PhysicalPartitionCollection value that identifies the collection of physical partitions in which the table data is stored.
示例
The following code example enumerates through each physical partition of each table in the AdventureWorks2012 database and displays the partitions row count.
C#
Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];
foreach (Table tb in db.Tables)
{
Foreach (PhysicalPartition pt in tb.PhysicalPartitions)
{
Console.WriteLine(pt.RowCount.ToString());
}
}
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)
{
Foreach ($pt in $tb.PhysicalPartitions)
{
Write-Host $pt.RowCount
}
}
请参阅
参考
Microsoft.SqlServer.Management.Smo 命名空间