Freigeben über


CheckTable Method

Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

The CheckTable method tests the integrity of database pages implementing storage for the referenced table and indexes defined on it.

Syntax

object
.CheckTable( )
as String

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT CheckTable(SQLDMO_LPBSTR pResult);
ms143015.note(de-de,SQL.90).gifHinweis:
SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Returns

A string that contains detailed status and error information. For errors with severity 11 or greater, the string is returned as a trappable error in the Err object in Visual Basic.

Hinweise

The CheckTable method is implemented using the Transact-SQL DBCC CHECKTABLE statement. The return value of the CheckTable method is a string representation of the error messages returned by DBCC CHECKTABLE.

Applies to:

Table Object

Siehe auch

Andere Ressourcen

DBCC CHECKTABLE (Transact-SQL)

Hilfe und Informationen

Informationsquellen für SQL Server 2005