Sdílet prostřednictvím


TableViewBase.EnumFragmentation Method (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.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Function EnumFragmentation ( _
    fragmentationOption As FragmentationOption, _
    partitionNumber As Integer _
) As DataTable
'Usage
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

Parameters

Return Value

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