Metodo Table.SwitchPartition (Int32, Table)
Switches the specified partition of the table to the specified target table specified (assuming the target table is not partitioned).
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
Public Sub SwitchPartition ( _
sourcePartitionNumber As Integer, _
targetTable As Table _
)
'Utilizzo
Dim instance As Table
Dim sourcePartitionNumber As Integer
Dim targetTable As Table
instance.SwitchPartition(sourcePartitionNumber, _
targetTable)
public void SwitchPartition(
int sourcePartitionNumber,
Table targetTable
)
public:
void SwitchPartition(
int sourcePartitionNumber,
Table^ targetTable
)
member SwitchPartition :
sourcePartitionNumber:int *
targetTable:Table -> unit
public function SwitchPartition(
sourcePartitionNumber : int,
targetTable : Table
)
Parametri
- 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.
Esempi
Utilizzo di filegroup e file per archiviare dati
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo