Método Table.SwitchPartition (Int32, Table, Int32)
Switches the specified source partition of the table to the specified target of the specified target table.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public Sub SwitchPartition ( _
sourcePartitionNumber As Integer, _
targetTable As Table, _
targetPartitionNumber As Integer _
)
'Uso
Dim instance As Table
Dim sourcePartitionNumber As Integer
Dim targetTable As Table
Dim targetPartitionNumber As Integer
instance.SwitchPartition(sourcePartitionNumber, _
targetTable, targetPartitionNumber)
public void SwitchPartition(
int sourcePartitionNumber,
Table targetTable,
int targetPartitionNumber
)
public:
void SwitchPartition(
int sourcePartitionNumber,
Table^ targetTable,
int targetPartitionNumber
)
member SwitchPartition :
sourcePartitionNumber:int *
targetTable:Table *
targetPartitionNumber:int -> unit
public function SwitchPartition(
sourcePartitionNumber : int,
targetTable : Table,
targetPartitionNumber : int
)
Parâmetros
- sourcePartitionNumber
Tipo: System.Int32
An Int32 value that specifies the partition number of the source partition.
- targetTable
Tipo: Microsoft.SqlServer.Management.Smo.Table
A Table object value that specifies the table that is in the required partition.
- targetPartitionNumber
Tipo: System.Int32
An Int32 value that specifies the partition number of the target partition.
Exemplos
Usando grupos de arquivos e arquivos para armazenar dados
Consulte também
Referência
Sobrecarregado SwitchPartition
Namespace Microsoft.SqlServer.Management.Smo