Table.SwitchPartition Method (Table)

Switches the partition of the table to the specified target table.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub SwitchPartition ( _
    targetTable As Table _
)
'Usage
Dim instance As Table 
Dim targetTable As Table

instance.SwitchPartition(targetTable)
public void SwitchPartition(
    Table targetTable
)
public:
void SwitchPartition(
    Table^ targetTable
)
member SwitchPartition : 
        targetTable:Table -> unit
public function SwitchPartition(
    targetTable : Table
)

Parameters

Examples

Using Filegroups and Files to Store Data

See Also

Reference

Table Class

SwitchPartition Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating, Altering, and Removing Tables

Tables

sp_addmergepartition (Transact-SQL)