Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)