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.

C#

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")

참고 항목

참조

Table 클래스

EnumLastStatisticsUpdates 오버로드

Microsoft.SqlServer.Management.Smo 네임스페이스

관련 자료

테이블 생성, 변경 및 제거

테이블

CREATE TABLE(Transact-SQL)