CheckTablesDataOnly 메서드 (RepairStructure)
참조된 데이터베이스의 모든 테이블 및 테이블에 정의된 모든 인덱스의 데이터를 저장하는 페이지에서 데이터의 무결성을 테스트하며, 여기에 지정된 복구 구조를 적용합니다.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
Public Function CheckTablesDataOnly ( _
repairStructure As RepairStructure _
) As StringCollection
‘사용 방법
Dim instance As Database
Dim repairStructure As RepairStructure
Dim returnValue As StringCollection
returnValue = instance.CheckTablesDataOnly(repairStructure)
public StringCollection CheckTablesDataOnly(
RepairStructure repairStructure
)
public:
StringCollection^ CheckTablesDataOnly(
RepairStructure repairStructure
)
member CheckTablesDataOnly :
repairStructure:RepairStructure -> StringCollection
public function CheckTablesDataOnly(
repairStructure : RepairStructure
) : StringCollection
매개 변수
- repairStructure
유형: Microsoft.SqlServer.Management.Smo. . :: . .RepairStructure
페이지 일관성 및 할당 구조를 검사하는 'physical only'와 같은 수행할 구조 검사 유형을 지정하는 RepairStructure 개체 값입니다.
반환 값
유형: System.Collections.Specialized. . :: . .StringCollection
데이터베이스의 테이블 무결성에 대한 보고서를 포함하는 StringCollection 개체 값입니다.
주의
This method is equivalent to the DBCC CHECKTABLE Transact-SQL command.
예
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Note, to use the StringCollection type the System.Collections.Specialized system namespace must be included in the imports statements.
Dim sc As StringCollection
'Run the CheckTables method and display the results from the returned StringCollection variable.
sc = db.CheckTables(RepairType.None)
Dim c As Integer
For c = 0 To sc.Count - 1
Console.WriteLine(sc.Item(c))
Next
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
$sc = new-object System.Collections.Specialized.StringCollection
$sc = $db.CheckTables([Microsoft.SqlServer.Management.Smo.RepairType]'None')
$c = 0
For ($c=0; $c -le $sc.Count - 1; $c++)
{
Write-Host $sc.Item($c)
}