Index.CheckIndex Method
Tests the integrity of database pages that store the index.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function CheckIndex As StringCollection
'Usage
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
Return Value
Type: System.Collections.Specialized.StringCollection
A StringCollection object value that contains the error messages generated by the integrity check.
Remarks
The CheckIndex method is implemented using the Transact-SQL DBCC CHECKTABLE statement.
Note
Indexes based on the UserDefinedTableType object cannot be checked and running this method will generate an exception.
Examples
Creating, Altering, and Removing Indexes
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace