Index.DropAndMove Method

 

Drops the index and re-creates the index in a specified filegroup.

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

NameDescription
System_CAPS_pubmethodDropAndMove(String)

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

System_CAPS_pubmethodDropAndMove(String, StringCollection)

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

Return to top
Show: