EnumFragmentation 方法 (FragmentationOption, Int32)

Enumerates information about fragments of data that are stored in a table or view on a specified partition, and with the option to specify how detailed the results should be.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Function EnumFragmentation ( _
    fragmentationOption As FragmentationOption, _
    partitionNumber As Integer _
) As DataTable
'用途
Dim instance As TableViewBase
Dim fragmentationOption As FragmentationOption
Dim partitionNumber As Integer
Dim returnValue As DataTable

returnValue = instance.EnumFragmentation(fragmentationOption, _
    partitionNumber)

public DataTable EnumFragmentation(
    FragmentationOption fragmentationOption,
    int partitionNumber
)

public:
DataTable^ EnumFragmentation(
    FragmentationOption fragmentationOption, 
    int partitionNumber
)

member EnumFragmentation : 
        fragmentationOption:FragmentationOption * 
        partitionNumber:int -> DataTable 

public function EnumFragmentation(
    fragmentationOption : FragmentationOption, 
    partitionNumber : int
) : DataTable

參數

• fragmentationOption
  型別：Microsoft.SqlServer.Management.Smo. . :: . .FragmentationOption
  A FragmentationOption object value that specifies the level of detail returned in the results.

• partitionNumber
  型別：System. . :: . .Int32
  An Int32 value that specifies the partition.

傳回值

型別：System.Data. . :: . .DataTable
A DataTable system object value that contains a list of information about the fragmented data in the table or view.

範例

使用資料庫物件

請參閱

參考

TableViewBase類別

TableViewBase 成員

EnumFragmentation 多載

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

資料表

檢視

CREATE TABLE (Transact-SQL)

CREATE VIEW (Transact-SQL)