Index.DropAndMove Method

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

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

Indexes
DROP INDEX (Transact-SQL)