Partager via


Méthode Table.EnumLastStatisticsUpdates (String)

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

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
Public Function EnumLastStatisticsUpdates ( _
    statname As String _
) As DataTable
'Utilisation
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

Paramètres

  • statname
    Type : System.String
    A String value that specifies the statistic counter to which to limit the results.

Valeur de retour

Type : 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.

Exemples

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

Voir aussi

Référence

Table Classe

Surcharge EnumLastStatisticsUpdates

Espace de noms Microsoft.SqlServer.Management.Smo

Autres ressources

Création, modification et suppression de tables

Tables

CREATE TABLE (Transact-SQL)