Table.CheckTable Method
Tests the integrity of database pages for the table and indexes defined on the table.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function CheckTable As StringCollection
'Usage
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
Return Value
Type: 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.
Remarks
This method is functionally equivalent to the Transact-SQL CHECK TABLE statement.
Examples
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()
}
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace