Freigeben über

  • Artikel

PhysicalPartitions-Eigenschaft

Ruft die physischen Partitionen ab, in denen die Tabellendaten gespeichert werden.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, GetType(PhysicalPartition))> _
Public ReadOnly Property PhysicalPartitions As PhysicalPartitionCollection
    Get
'Usage
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

Eigenschaftswert

Typ: Microsoft.SqlServer.Management.Smo. . :: . .PhysicalPartitionCollection
Ein PhysicalPartitionCollection-Wert, der die Auflistung physischer Partitionen identifiziert, in denen die Tabellendaten gespeichert werden.

Beispiele

The following code example enumerates through each physical partition of each table in the AdventureWorks2008R2 database and displays the partitions row count.

C#

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

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

Foreach ($tb in $db.Tables) 
{
   Foreach ($pt in $tb.PhysicalPartitions)
   {
      Write-Host $pt.RowCount
   }
}