Database.PartitionFunctions Database.PartitionFunctions Database.PartitionFunctions Property

Definition

Gets a collection of PartitionFunction objects. Each PartitionFunction object represents a partition function defined on the database.

public:
 property Microsoft::SqlServer::Management::Smo::PartitionFunctionCollection ^ PartitionFunctions { Microsoft::SqlServer::Management::Smo::PartitionFunctionCollection ^ 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.PartitionFunction))]
public Microsoft.SqlServer.Management.Smo.PartitionFunctionCollection PartitionFunctions { get; }
Public ReadOnly Property PartitionFunctions As PartitionFunctionCollection
Property Value

A PartitionFunctionCollection object that represents all the partition functions 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 function can be referenced by using this collection by specifying the name of the partition function. To add a new partition function to the collection, call the partition function constructor.

Applies to