Any suggestions? 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: 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.

Return to top
Show:
© 2016 Microsoft