Table.SwitchPartition Method

Definition

Namespace:

Microsoft.SqlServer.Management.Smo

Assembly:

Microsoft.SqlServer.Smo.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Overloads

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.

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

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

targetPartitionNumber

Int32

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

targetTable

Table

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

targetTable

Table

targetPartitionNumber

Int32