Table.SwitchPartition Method
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
| SwitchPartition(Table) |
Switches the current table to the table specified with targetTable. |
| SwitchPartition(Table, Int32) |
Switches the current table to the partition with the partition number targetPartitionNumber of the table specified with targetTable. |
| SwitchPartition(Int32, Table) |
Switches the partition with the partition number sourcePartitionNumber of the current table to the table specified with targetTable. This assumes that the target table is not partitioned. |
| SwitchPartition(Int32, Table, Int32) |
Switches the partition with the partition number sourcePartitionNumber of the current table to the partition with the partition number targetPartitionNumber of the table specified with targetTable. |
Switches the current table to the table specified with targetTable.
public void SwitchPartition(Microsoft.SqlServer.Management.Smo.Table targetTable);member this.SwitchPartition : Microsoft.SqlServer.Management.Smo.Table -> unitPublic Sub SwitchPartition (targetTable As Table)Parameters
- targetTable
- Table
Applies to
Microsoft.SqlServer.SqlManagementObjects 160.2004021.0 ja Microsoft.SqlServer.SqlManagementObjects 150.18208.0
| Toode | Versioonid |
|---|---|
| Microsoft.SqlServer.SqlManagementObjects | 150.18208.0, 160.2004021.0 |
Switches the current table to the partition with the partition number targetPartitionNumber of the table specified with targetTable.
public void SwitchPartition(Microsoft.SqlServer.Management.Smo.Table targetTable, int targetPartitionNumber);member this.SwitchPartition : Microsoft.SqlServer.Management.Smo.Table * int -> unitPublic Sub SwitchPartition (targetTable As Table, targetPartitionNumber As Integer)Parameters
- targetTable
- Table
- targetPartitionNumber
- Int32
Applies to
Microsoft.SqlServer.SqlManagementObjects 160.2004021.0 ja Microsoft.SqlServer.SqlManagementObjects 150.18208.0
| Toode | Versioonid |
|---|---|
| Microsoft.SqlServer.SqlManagementObjects | 150.18208.0, 160.2004021.0 |
Switches the partition with the partition number sourcePartitionNumber of the current table to the table specified with targetTable. This assumes that the target table is not partitioned.
public void SwitchPartition(int sourcePartitionNumber, Microsoft.SqlServer.Management.Smo.Table targetTable);member this.SwitchPartition : int * Microsoft.SqlServer.Management.Smo.Table -> unitPublic Sub SwitchPartition (sourcePartitionNumber As Integer, targetTable As Table)Parameters
- sourcePartitionNumber
- Int32
- targetTable
- Table
Applies to
Microsoft.SqlServer.SqlManagementObjects 160.2004021.0 ja Microsoft.SqlServer.SqlManagementObjects 150.18208.0
| Toode | Versioonid |
|---|---|
| Microsoft.SqlServer.SqlManagementObjects | 150.18208.0, 160.2004021.0 |
Switches the partition with the partition number sourcePartitionNumber of the current table to the partition with the partition number targetPartitionNumber of the table specified with targetTable.
public void SwitchPartition(int sourcePartitionNumber, Microsoft.SqlServer.Management.Smo.Table targetTable, int targetPartitionNumber);member this.SwitchPartition : int * Microsoft.SqlServer.Management.Smo.Table * int -> unitPublic Sub SwitchPartition (sourcePartitionNumber As Integer, targetTable As Table, targetPartitionNumber As Integer)Parameters
- sourcePartitionNumber
- Int32
- targetTable
- Table
- targetPartitionNumber
- Int32
Applies to
Microsoft.SqlServer.SqlManagementObjects 160.2004021.0 ja Microsoft.SqlServer.SqlManagementObjects 150.18208.0
| Toode | Versioonid |
|---|---|
| Microsoft.SqlServer.SqlManagementObjects | 150.18208.0, 160.2004021.0 |