Partager via

  • Article

Propriété PhysicalPartitions

Obtient les partitions physiques dans lesquelles les données de la table sont stockées.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

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

Valeur de propriété

Type : Microsoft.SqlServer.Management.Smo. . :: . .PhysicalPartitionCollection
Valeur PhysicalPartitionCollection qui identifie la collection de partitions physiques dans lesquelles les données de table sont stockées.

Exemples

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
   }
}