This topic has not yet been rated - Rate this topic

Database.CheckTables Method (RepairType, RepairOptions)

SQL Server 2012

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

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

member CheckTables : 
        repairType:RepairType * 
        repairOptions:RepairOptions -> StringCollection

repairType: Type: Microsoft.SqlServer.Management.Smo.RepairType
A RepairType object that specifies the repair mode.

repairOptions: Type: Microsoft.SqlServer.Management.Smo.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.

Type: System.Collections.Specialized.StringCollection
A StringCollection object value that contains a report about the integrity of the tables and indexes in the database.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions