Index.DropAndMove Method (String)

项目
12/15/2008

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

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Sub DropAndMove ( _
    fileGroup As String _
)

public void DropAndMove (
    string fileGroup
)

public:
void DropAndMove (
    String^ fileGroup
)

public void DropAndMove (
    String fileGroup
)

public function DropAndMove (
    fileGroup : String
)

参数

fileGroup
A String value that specifies the name of the filegroup.

备注

The OnlineIndexOperation and MaximumDegreeOfParallelism properties affect this method. The parent Table object needs to be refreshed by calling the Refresh method to reflect the latest state, because this will not be updated by this method automatically.

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

How to: Create a Non-Clustered, Composite Index in Visual Basic .NET

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台