dbcc tables

See Reference Manual: Tables for details.

dbcc_config

The dbcc_config table describes the currently executing or last completed dbcc checkstorage operation. It defines:

dbcc_counters

The dbcc_counters table stores the results of the analysis performed by dbcc checkstorage. Counters are maintained for each database, table, index, partition, device, and invocation of dbcc.

dbcc_fault_params

The dbcc_fault_params table provides additional descriptive information for a fault entered in the dbcc_faults table.

dbcc_faults

The dbcc_faults table provides a description of each fault detected by dbcc checkstorage.

dbcc_operation_log

The dbcc_operation_log table records the use of the dbcc checkstorage operations.

dbcc_operation_results

The dbcc_operation_results table provides additional descriptive information for an operation recorded in the dbcc_operation_log table.

dbcc_types

The dbcc_types table provides the definitions of the data types used by dbcc checkstorage. This table is not actually used by the dbcc stored procedures. It is provided to facilitate the use of the other tables in dbccdb, and to document the semantics of the data types. Type codes for operation configuration, analysis data reported, fault classification, and fault report parameters are included. If you create your own stored procedures for generating reports, the values listed in the type_name column can be used as report headings.