Table.SwitchPartition Table.SwitchPartition Table.SwitchPartition Method

Definition

Overloads

SwitchPartition(Table) SwitchPartition(Table) SwitchPartition(Table)

Switches the current table to the table specified with targetTable.

SwitchPartition(Table, Int32) SwitchPartition(Table, Int32) SwitchPartition(Table, Int32)

Switches the current table to the partition with the partition number targetPartitionNumber of the table specified with targetTable.

SwitchPartition(Int32, Table) SwitchPartition(Int32, Table) 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) SwitchPartition(Int32, Table, Int32) 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.

SwitchPartition(Table) SwitchPartition(Table) SwitchPartition(Table)

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 -> unit
Public Sub SwitchPartition (targetTable As Table)

Parameters

targetTable
Table Table Table

SwitchPartition(Table, Int32) SwitchPartition(Table, Int32) SwitchPartition(Table, Int32)

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 -> unit
Public Sub SwitchPartition (targetTable As Table, targetPartitionNumber As Integer)

Parameters

targetTable
Table Table Table
targetPartitionNumber
Int32 Int32 Int32

SwitchPartition(Int32, Table) SwitchPartition(Int32, Table) 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.

public void SwitchPartition (int sourcePartitionNumber, Microsoft.SqlServer.Management.Smo.Table targetTable);
member this.SwitchPartition : int * Microsoft.SqlServer.Management.Smo.Table -> unit
Public Sub SwitchPartition (sourcePartitionNumber As Integer, targetTable As Table)

Parameters

sourcePartitionNumber
Int32 Int32 Int32
targetTable
Table Table Table

SwitchPartition(Int32, Table, Int32) SwitchPartition(Int32, Table, Int32) 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.

public void SwitchPartition (int sourcePartitionNumber, Microsoft.SqlServer.Management.Smo.Table targetTable, int targetPartitionNumber);
member this.SwitchPartition : int * Microsoft.SqlServer.Management.Smo.Table * int -> unit
Public Sub SwitchPartition (sourcePartitionNumber As Integer, targetTable As Table, targetPartitionNumber As Integer)

Parameters

sourcePartitionNumber
Int32 Int32 Int32
targetTable
Table Table Table
targetPartitionNumber
Int32 Int32 Int32

Applies to