Метод Table.EnumLastStatisticsUpdates

Enumerates a list of information about the most recent statistics updates.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
Public Function EnumLastStatisticsUpdates As DataTable
'Применение
Dim instance As Table 
Dim returnValue As DataTable 

returnValue = instance.EnumLastStatisticsUpdates()

public DataTable EnumLastStatisticsUpdates()

public:
DataTable^ EnumLastStatisticsUpdates()

member EnumLastStatisticsUpdates : unit -> DataTable

public function EnumLastStatisticsUpdates() : DataTable

Возвращаемое значение

Тип: 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 the 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"];
lastStatisticsUpdates[];
Table tb1 = db.Tables[0];
Table tb2 = db.Tables[1];

DataTable[] lastSUpdates = new DataTable[2] {tb1.EnumLastStatisticsUpdates(), tb2.EnumLastStatisticsUpdates()}

Powershell

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

$tb1 = $db.Tables[0]
$tb2 = $db.Tables[1]
$lastSUpdates = @($tb1.EnumLastStatisticsUpdates(), $tb2.EnumLastStatisticsUpdates());