Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
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