Export (0) Print
Expand All

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: 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: Int32
An Int32 value that specifies the partition number of the target partition.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft