Enumerates information about fragments of data stored in a table or view on a specified partition and with the option to specify how detailed to make the results returned.
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
语法
声明
Public Function EnumFragmentation ( _
fragmentationOption As FragmentationOption, _
partitionNumber As Integer _
) As DataTable
public DataTable EnumFragmentation (
FragmentationOption fragmentationOption,
int partitionNumber
)
public:
DataTable^ EnumFragmentation (
FragmentationOption fragmentationOption,
int partitionNumber
)
public DataTable EnumFragmentation (
FragmentationOption fragmentationOption,
int partitionNumber
)
public function EnumFragmentation (
fragmentationOption : FragmentationOption,
partitionNumber : int
) : DataTable
参数
- fragmentationOption
A FragmentationOption object value that specifies the level of detail returned in the results.
- partitionNumber
An Int32 value that specifies the partition.
返回值
A DataTable system object value that contains a list of information about the fragmented data in the table or view.
备注
仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。
示例
How to: Create, Alter, and Remove a Table in Visual Basic .NET
How to: Create, Alter, and Remove a View 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 的硬件和软件要求。
目标平台
有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。
请参阅
参考
TableViewBase Class
TableViewBase Members
Microsoft.SqlServer.Management.Smo Namespace
其他资源
Working with Database Objects
表
视图(数据库引擎)
CREATE TABLE (Transact-SQL)
CREATE VIEW (Transact-SQL)