Index.DropAndMove Method

Definition

Namespace:

Microsoft.SqlServer.Management.Smo

Assembly:

Microsoft.SqlServer.Smo.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Overloads

DropAndMove(String)	Drops a clustered index and moves the underlying table data to the specified File Group.
DropAndMove(String, StringCollection)	Drops a clustered index and moves the underlying table data to the partition scheme with the parameters specified with partitionSchemeParameters.

DropAndMove(String)

Drops a clustered index and moves the underlying table data to the specified File Group.

public void DropAndMove (string fileGroup);

member this.DropAndMove : string -> unit

Public Sub DropAndMove (fileGroup As String)

Parameters

fileGroup

String

DropAndMove(String, StringCollection)

Drops a clustered index and moves the underlying table data to the partition scheme with the parameters specified with partitionSchemeParameters.

public void DropAndMove (string partitionScheme, System.Collections.Specialized.StringCollection partitionSchemeParameters);

member this.DropAndMove : string * System.Collections.Specialized.StringCollection -> unit

Public Sub DropAndMove (partitionScheme As String, partitionSchemeParameters As StringCollection)

Parameters

partitionScheme

String

partitionSchemeParameters

StringCollection