Partilhar via

Database.CheckTables Method

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo
Assembly:
Microsoft.SqlServer.Smo.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

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

StringCollection

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

StringCollection

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

StringCollection

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
maxDOP
Nullable<Int64>

Returns

StringCollection

Messages returned by DBCC CHECKDB

Applies to