Table.EnumLastStatisticsUpdates 方法 (String)

Enumerates a list of information about the most recent statistics updates for the specified statistic counter.

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

語法

'宣告
Public Function EnumLastStatisticsUpdates ( _
    statname As String _
) As DataTable
'用途
Dim instance As Table 
Dim statname As String 
Dim returnValue As DataTable 

returnValue = instance.EnumLastStatisticsUpdates(statname)

public DataTable EnumLastStatisticsUpdates(
    string statname
)

public:
DataTable^ EnumLastStatisticsUpdates(
    String^ statname
)

member EnumLastStatisticsUpdates : 
        statname:string -> DataTable

public function EnumLastStatisticsUpdates(
    statname : String
) : DataTable

參數

statname
型別：System.String
A String value that specifies the statistic counter to which to limit the results.

傳回值

型別：System.Data.DataTable
A DataTable system object value that contains a list of information about the most recent statistics updates.

Column	Data type	Description
Name	String	The name of key or index on which the statistic counter is based.
LastUpdated	DateTime	The date and time when the statistics were last updated.

範例

The following code example demonstrates how to enumerate statistic update information.

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];
Table tb = db.Tables["Address", "Person"];

DataTable dt;
dt = tb.EnumLastStatisticsUpdates("PK_Address_AddressID");

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

$tb = $db.Tables.Item("Address", "Person")
$dt = $tb.EnumLastStatisticsUpdates("PK_Address_AddressID")