Index.DropAndMove Method

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

備註

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

多載清單

名稱 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.

請參閱

參考

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

其他資源

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