Table.CheckTable 方法

项目
04/26/2013

Tests the integrity of database pages for the table and indexes defined on the table.

命名空间： Microsoft.SqlServer.Management.Smo
程序集： Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
Public Function CheckTable As StringCollection
用法
Dim instance As Table 
Dim returnValue As StringCollection 

returnValue = instance.CheckTable()

public StringCollection CheckTable()

public:
StringCollection^ CheckTable()

member CheckTable : unit -> StringCollection

public function CheckTable() : StringCollection

返回值

类型：System.Collections.Specialized.StringCollection
A StringCollection system object value that contains the results of the checking the integrity of the table, including the number of rows and the number of pages.

注释

This method is functionally equivalent to the Transact-SQL CHECK TABLE statement.

示例

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

foreach (Table tb in db.Tables)
{
   tb.CheckTable();
}

Powershell

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

foreach ($tb in $db.Tables)
{
   $tb.CheckTable()
}