dbccdb Tables

In addition to the standard system tables included in all databases, the dbcc management database, dbccdb, contains seven tables that define inputs to and outputs from dbcc checkstorage. It also contains at least two workspaces.

• dbccdb Workspaces
  Workspaces are special tables in dbccdb that store intermediate results of the dbcc checkstorage operation.
• dbccdb Log
  The results of each dbcc checkstorage operation are recorded in the dbccdb log. Updates to the text and scan workspaces are not recorded there.
• dbcc_config
  The dbcc_config table describes the currently executing or last completed dbcc checkstorage operation.
• 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_exclusions
  The dbcc_exclusions table stores the faults, tables or a combination of them that should be excluded from processing by checkverify and fault reporting via sp_dbcc_faultreport.
• 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
  Provides the definitions of the datatypes used by dbcc checkstorage.