Export (0) Print
Expand All

Table.SwitchPartition Method (Int32, Table)

Switches the specified partition of the table to the specified target table specified (assuming the target table is not partitioned).

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

public void SwitchPartition(
	int sourcePartitionNumber,
	Table targetTable


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

Community Additions

© 2015 Microsoft