CheckIndex 方法

Tests the integrity of database pages that store the index.

命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Function CheckIndex As StringCollection
'用途
Dim instance As Index
Dim returnValue As StringCollection

returnValue = instance.CheckIndex()

public StringCollection CheckIndex()

public:
StringCollection^ CheckIndex()

member CheckIndex : unit -> StringCollection

public function CheckIndex() : StringCollection

型別：System.Collections.Specialized. . :: . .StringCollection
A StringCollection object value that contains the error messages generated by the integrity check.

The CheckIndex method is implemented using the Transact-SQL DBCC CHECKTABLE statement.

[!附註]

Indexes based on the UserDefinedTableType object cannot be checked and running this method will generate an exception.