DBCC tables

These are very brief descriptions for Adaptive Server dbcc tables. See Reference Manual: Tables for complete information.

dbcc_config

Describes the currently executing or last completed dbcc checkstorage operation. Columns: dbid, type_code, value, stringvalue

dbcc_counters

Stores the results of the analysis performed by dbcc checkstorage. Columns: dbid, id, indid, partitionid, devid, opid, type_code, value

dbcc_exclusions

Stores the faults, tables or a combination of them that should be excluded from processing by checkverify and fault reporting via sp_dbcc_faultreport. Columns: dbid, type, fault_type, table_name

dbcc_fault_params

Provides additional descriptive information for a fault entered in the dbcc_faults table. Columns: dbid, opid, faultid, type_code, intvalue, realvalue, binaryvalue, stringvalue, datevalue

dbcc_faults

Provides a description of each fault detected by dbcc checkstorage. Columns: dbid, id, indid, partitionid, devid, opid, faultid, type_code, status

dbcc_operation_log

Records the use of the dbcc checkstorage operations. Columns: dbid, opid, optype, suid, start, finish, seq, id, maxseq

dbcc_operation_results

Provides additional descriptive information for an operation recorded in the dbcc_operation_log table. Columns: dbid, opid, optype, type_code, intvalue, realvalue, binaryvalue, stringvalue, datevalue, seq

dbcc_types

Provides the definitions of the datatypes used by dbcc checkstorage.