Partilhar via


Método Table.CheckTable

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
Public Function CheckTable As StringCollection
'Uso
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

Valor de retorno

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

Comentários

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

Exemplos

C#

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()
}

Consulte também

Referência

Table Classe

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Tabelas

CREATE TABLE (Transact-SQL)