Table.PhysicalPartitions Propiedad

Gets the physical partitions in which the table data is stored.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

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

Valor de la propiedad

Tipo: Microsoft.SqlServer.Management.Smo.PhysicalPartitionCollection
A PhysicalPartitionCollection value that identifies the collection of physical partitions in which the table data is stored.

Ejemplos

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

Vea también

Referencia

Table Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

Tablas

CREATE TABLE (Transact-SQL)