The standard, supported dbcc commands used in this document are as follows:
dbcc Command |
Purpose |
tablealloc |
checks allocation information for the specified table. |
textalloc |
checks allocation information in text pages for the specified table. |
indexalloc |
checks allocation information for the specified index. |
checkalloc |
runs the same checks as tablealloc, for all pages in a database. |
checktable |
checks the integrity of data and index pages in the specified table. |
checkdb |
runs the same checks as checktable, for all tables in a database. |
checkstorage |
combines some of the checks of the above commands, and provides additional checks. |
checkverify |
Checks faults identified by checkstorage to see if they are indeed hard errors. |
reindex |
checks the integrity of indexes on user tables. prints a message when it finds the first index error and then drops/recreates the index. |
For a complete description of these commands, see the System Administration Guide.
