Export (0) Print
Expand All

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)

public StringCollection CheckIndex()

Return Value

Type: 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.

NoteNote

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft