Share via

Index.DropAndMove Method

  • Article

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

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Overload List

Name Description
Index.DropAndMove (String)
Drops a clustered index and moves the underlying table data to the specified filegroup.
Index.DropAndMove (String, StringCollection)
Drops a clustered index and moves the underlying table data to the partition scheme with the specified with partition scheme parameters.

See Also

Reference

Index Class
Index Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating, Altering, and Removing Indexes
Indexes
DROP INDEX (Transact-SQL)