PhysicalPartitions Propiedad
Obtiene las particiones físicas en las que están almacenados los datos de la tabla.
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
Valor PhysicalPartitionCollection que identifica la colección de particiones físicas en las que están almacenados los datos de la tabla.
Ejemplos
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
}
}
Vea también