Database.PartitionSchemes Database.PartitionSchemes Database.PartitionSchemes Property

Definition

Gets a collection of PartitionScheme objects. Each PartitionScheme object represents a partition scheme defined on the database.

public:
 property Microsoft::SqlServer::Management::Smo::PartitionSchemeCollection ^ PartitionSchemes { Microsoft::SqlServer::Management::Smo::PartitionSchemeCollection ^ get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcObject(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcContainerRelationship.ObjectContainer, Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcContainerCardinality.ZeroToAny, typeof(Microsoft.SqlServer.Management.Smo.PartitionScheme))]
public Microsoft.SqlServer.Management.Smo.PartitionSchemeCollection PartitionSchemes { get; }
Public ReadOnly Property PartitionSchemes As PartitionSchemeCollection
Property Value

A PartitionSchemeCollection object that represents all the partition schemes defined on the database.

Examples

VB

Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Display all the partition functions and schemes on the database.  
Dim pf As PartitionFunction  
For Each pf In db.PartitionFunctions  
   Console.WriteLine(pf.Name)  
Next  
Dim ps As PartitionScheme  
For Each ps In db.PartitionSchemes  
   Console.WriteLine(ps.Name)  
Next  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  
Foreach ($pf in $db.PartitionFunctions)  
{  
   Write-Host $pf.Name  
}  
Foreach ($ps in $db.LogFiles)  
{  
   Write-Host $ps.Name  
}  

Remarks

Specific partition schemes can be referenced by using this collection by specifying the name of the partition scheme. To add a new partition scheme to the collection, call the partition scheme constructor.

Applies to