Database.CheckTables Database.CheckTables Method

Definition

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

Overloads

CheckTables(RepairType) CheckTables(RepairType)

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

CheckTables(RepairType, RepairOptions) CheckTables(RepairType, RepairOptions)

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

CheckTables(RepairType, RepairStructure) CheckTables(RepairType, RepairStructure)

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

CheckTables(RepairType, RepairOptions, RepairStructure, Nullable<Int64>)

Checks the tables in the collection with the specified repair type, options and structure.

CheckTables(RepairType) CheckTables(RepairType)

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

public:
 System::Collections::Specialized::StringCollection ^ CheckTables(Microsoft::SqlServer::Management::Smo::RepairType repairType);
public System.Collections.Specialized.StringCollection CheckTables (Microsoft.SqlServer.Management.Smo.RepairType repairType);
Parameters
repairType
RepairType RepairType

A RepairType object that specifies the repair mode.

Returns

A StringCollection object that contains a report about the integrity of the tables and indexes in the database.

CheckTables(RepairType, RepairOptions) CheckTables(RepairType, RepairOptions)

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

public:
 System::Collections::Specialized::StringCollection ^ CheckTables(Microsoft::SqlServer::Management::Smo::RepairType repairType, Microsoft::SqlServer::Management::Smo::RepairOptions repairOptions);
public System.Collections.Specialized.StringCollection CheckTables (Microsoft.SqlServer.Management.Smo.RepairType repairType, Microsoft.SqlServer.Management.Smo.RepairOptions repairOptions);
Parameters
repairType
RepairType RepairType

A RepairType object that specifies the repair mode.

repairOptions
RepairOptions RepairOptions

A RepairOptions object value that specifies the repair options, such as whether to perform an estimate only and what type of messages to include in the returned report.

Returns

A StringCollection object value that contains a report about the integrity of the tables and indexes in the database.

CheckTables(RepairType, RepairStructure) CheckTables(RepairType, RepairStructure)

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

public:
 System::Collections::Specialized::StringCollection ^ CheckTables(Microsoft::SqlServer::Management::Smo::RepairType repairType, Microsoft::SqlServer::Management::Smo::RepairStructure repairStructure);
public System.Collections.Specialized.StringCollection CheckTables (Microsoft.SqlServer.Management.Smo.RepairType repairType, Microsoft.SqlServer.Management.Smo.RepairStructure repairStructure);
Parameters
repairType
RepairType RepairType

A RepairType object that specifies the repair mode.

repairStructure
RepairStructure RepairStructure

A RepairStructure object value that specifies the type of structural checks to perform, such as 'physical only' that checks the page consistency and allocation structures.

Returns

A StringCollection object value that contains a report about the integrity of the tables and indexes in the database.

CheckTables(RepairType, RepairOptions, RepairStructure, Nullable<Int64>)

Checks the tables in the collection with the specified repair type, options and structure.

public System.Collections.Specialized.StringCollection CheckTables (Microsoft.SqlServer.Management.Smo.RepairType repairType, Microsoft.SqlServer.Management.Smo.RepairOptions repairOptions, Microsoft.SqlServer.Management.Smo.RepairStructure repairStructure, Nullable<long> maxDOP = null);
Parameters
repairType
RepairType RepairType

The repair type.

repairOptions
RepairOptions RepairOptions

The repair options.

repairStructure
RepairStructure RepairStructure

The repair structure.

maxDOP
Nullable<Int64>

The specified maxdop.

Returns

The tables in the collection to check.

Applies to