Свойство 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
   }
}

См. также

Справочник

Table Класс

Пространство имен Microsoft.SqlServer.Management.Smo

Другие ресурсы

Таблицы

Инструкция CREATE TABLE (Transact-SQL)