RepairOptions 열거형
The RepairOptions enumeration contains values that are used to specify the repair options that are used when checking data in a table.
이 열거형에는 해당 멤버 값에 대한 비트 조합이 가능한 FlagsAttribute 특성이 있습니다.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.SqlEnum(Microsoft.SqlServer.SqlEnum.dll)
구문
‘선언
<FlagsAttribute> _
Public Enumeration RepairOptions
‘사용 방법
Dim instance As RepairOptions
[FlagsAttribute]
public enum RepairOptions
[FlagsAttribute]
public enum class RepairOptions
[<FlagsAttribute>]
type RepairOptions
public enum RepairOptions
멤버
| 멤버 이름 | 설명 | |
|---|---|---|
| AllErrorMessages | Displays all reported errors per object. If it is not specified, 200 error messages are displayed for each object. The maximum is 1000. | |
| EstimateOnly | Requests the estimated amount of tempdb space that is required to run the CheckTables method. The actual database check is not performed. | |
| ExtendedLogicalChecks | Starting with SQL Server 2008, performs logical consistency checks on an indexed view, XML indexes, and spatial indexes. | |
| NoInformationMessages | Specifies that no information messages will be displayed during the repair operation. | |
| None | No repair options specified. | |
| TableLock | Limits the checks that are performed. The database catalogs are not checked for consistency, and Service Broker data is not validated. |
주의
The RepairOptions enumeration class is served by the T:Microsoft.SqlServer.Management.Smo.Database.CheckTables(Microsoft.SqlServer.Management.Smo.RepairOptions) method.