Table.SwitchPartition Method

Switches the partition of the table.

Overload List

Name	Description
Table.SwitchPartition (Table)	Switches the partition of the table to the specified target table.
Table.SwitchPartition (Int32, Table)	Switches the specified partition of the table to the specified target table specified (assuming the target table is not partitioned).
Table.SwitchPartition (Table, Int32)	Switches the table to the partition with the specified partition number of the specified target table.
Table.SwitchPartition (Int32, Table, Int32)	Switches the specified source partition of the table to the specified target of the specified target table.

See Also

Reference

Table Class
Table Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating, Altering, and Removing Tables
Tables
sp_addmergepartition (Transact-SQL)