Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Table.SwitchPartition Method (Int32, Table, Int32)

Switches the specified source partition of the table to the specified target of the specified target table.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public void SwitchPartition(
	int sourcePartitionNumber,
	Table targetTable,
	int targetPartitionNumber
)

Parameters

sourcePartitionNumber
Type: System.Int32
An Int32 value that specifies the partition number of the source partition.
targetTable
Type: Microsoft.SqlServer.Management.Smo.Table
A Table object value that specifies the table that is in the required partition.
targetPartitionNumber
Type: System.Int32
An Int32 value that specifies the partition number of the target partition.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.