SwitchPartition 方法 (Table, Int32)

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

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Sub SwitchPartition ( _
    targetTable As Table, _
    targetPartitionNumber As Integer _
)
'用途
Dim instance As Table
Dim targetTable As Table
Dim targetPartitionNumber As Integer

instance.SwitchPartition(targetTable, _
    targetPartitionNumber)

public void SwitchPartition(
    Table targetTable,
    int targetPartitionNumber
)

public:
void SwitchPartition(
    Table^ targetTable, 
    int targetPartitionNumber
)

member SwitchPartition : 
        targetTable:Table * 
        targetPartitionNumber:int -> unit 

public function SwitchPartition(
    targetTable : Table, 
    targetPartitionNumber : int
)

參數

• targetTable
  型別：Microsoft.SqlServer.Management.Smo. . :: . .Table
  A Table object value that specifies the table that is in the required partition.

• targetPartitionNumber
  型別：System. . :: . .Int32
  An Int32 value that specifies the partition number of the target partition.

範例

使用檔案群組和檔案來儲存資料

請參閱

參考

Table類別

Table 成員

SwitchPartition 多載

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

建立、改變和移除資料表

資料表

sp_addmergepartition (Transact-SQL)