Database.CheckTables Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
CheckTables(RepairType) |
Invokes DBCC CHECKDB with the given repair type and NO_INFOMSGS |
CheckTables(RepairType, RepairOptions) |
Invokes DBCC CHECKDB with the given repair type and repair options |
CheckTables(RepairType, RepairStructure) |
Invokes DBCC CHECKDB with the given repair type and repair structure |
CheckTables(RepairType, RepairOptions, RepairStructure, Nullable<Int64>) |
Invokes DBCC CHECKDB with the given options |
CheckTables(RepairType)
Invokes DBCC CHECKDB with the given repair type and NO_INFOMSGS
public System.Collections.Specialized.StringCollection CheckTables (Microsoft.SqlServer.Management.Smo.RepairType repairType);
member this.CheckTables : Microsoft.SqlServer.Management.Smo.RepairType -> System.Collections.Specialized.StringCollection
Public Function CheckTables (repairType As RepairType) As StringCollection
Parameters
- repairType
- RepairType
Returns
Applies to
CheckTables(RepairType, RepairOptions)
Invokes DBCC CHECKDB with the given repair type and repair options
public System.Collections.Specialized.StringCollection CheckTables (Microsoft.SqlServer.Management.Smo.RepairType repairType, Microsoft.SqlServer.Management.Smo.RepairOptions repairOptions);
member this.CheckTables : Microsoft.SqlServer.Management.Smo.RepairType * Microsoft.SqlServer.Management.Smo.RepairOptions -> System.Collections.Specialized.StringCollection
Public Function CheckTables (repairType As RepairType, repairOptions As RepairOptions) As StringCollection
Parameters
- repairType
- RepairType
- repairOptions
- RepairOptions
Returns
Messages returned by DBCC CHECKDB
Applies to
CheckTables(RepairType, RepairStructure)
Invokes DBCC CHECKDB with the given repair type and repair structure
public System.Collections.Specialized.StringCollection CheckTables (Microsoft.SqlServer.Management.Smo.RepairType repairType, Microsoft.SqlServer.Management.Smo.RepairStructure repairStructure);
member this.CheckTables : Microsoft.SqlServer.Management.Smo.RepairType * Microsoft.SqlServer.Management.Smo.RepairStructure -> System.Collections.Specialized.StringCollection
Public Function CheckTables (repairType As RepairType, repairStructure As RepairStructure) As StringCollection
Parameters
- repairType
- RepairType
- repairStructure
- RepairStructure
Returns
Messages returned by DBCC CHECKDB
Applies to
CheckTables(RepairType, RepairOptions, RepairStructure, Nullable<Int64>)
Invokes DBCC CHECKDB with the given options
public System.Collections.Specialized.StringCollection CheckTables (Microsoft.SqlServer.Management.Smo.RepairType repairType, Microsoft.SqlServer.Management.Smo.RepairOptions repairOptions, Microsoft.SqlServer.Management.Smo.RepairStructure repairStructure, long? maxDOP = default);
member this.CheckTables : Microsoft.SqlServer.Management.Smo.RepairType * Microsoft.SqlServer.Management.Smo.RepairOptions * Microsoft.SqlServer.Management.Smo.RepairStructure * Nullable<int64> -> System.Collections.Specialized.StringCollection
Public Function CheckTables (repairType As RepairType, repairOptions As RepairOptions, repairStructure As RepairStructure, Optional maxDOP As Nullable(Of Long) = Nothing) As StringCollection
Parameters
- repairType
- RepairType
- repairOptions
- RepairOptions
- repairStructure
- RepairStructure
Returns
Messages returned by DBCC CHECKDB