PartitionFunction.MergeRangePartition Method

Merges two existing range partitions based on the specified boundary value.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub MergeRangePartition ( _
    boundaryValue As Object _
)
'Usage
Dim instance As PartitionFunction 
Dim boundaryValue As Object

instance.MergeRangePartition(boundaryValue)
public void MergeRangePartition(
    Object boundaryValue
)
public:
void MergeRangePartition(
    Object^ boundaryValue
)
member MergeRangePartition : 
        boundaryValue:Object -> unit
public function MergeRangePartition(
    boundaryValue : Object
)

Parameters

  • boundaryValue
    Type: System.Object
    An Object system object that specifies the boundary value that will be used to demarcate the two partitions resulting from the split.

Remarks

The boundary value supplied should be an existing boundary value within the partition function. Data is moved to the resulting merged partition.

Examples

Using Filegroups and Files to Store Data

See Also

Reference

PartitionFunction Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE PARTITION FUNCTION (Transact-SQL)