Table.CheckTable Method

Artikkeli
12/03/2008

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

public StringCollection CheckTable ()

public:
StringCollection^ CheckTable ()

public StringCollection CheckTable ()

public function CheckTable () : StringCollection

Return Value

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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Create, Alter, and Remove a Table in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms