Table.CheckTableDataOnly Method

  • Makale

Tests the integrity of database pages for the table data defined on the table.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Function CheckTableDataOnly As StringCollection

public StringCollection CheckTableDataOnly ()

public:
StringCollection^ CheckTableDataOnly ()

public StringCollection CheckTableDataOnly ()

public function CheckTableDataOnly () : 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 tablename NOINDEX 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

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

See Also

Reference

Table Class
Table Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating, Altering, and Removing Tables
Tables
CREATE TABLE (Transact-SQL)