Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switches the partition of the table.
Remarks
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
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
Using Table and Index Partitioning
Creating, Altering, and Removing Tables
Tables
sp_addmergepartition (Transact-SQL)