Question
DBCC CHECKDB versus DBCC CHECKTABLE: what differs, and when should each run?
Answer
CHECKDB validates allocation, structural, and logical integrity for the whole database. CHECKTABLE validates one table or indexed view and its indexes. Run CHECKDB on the full maintenance cadence; use CHECKTABLE for focused investigation or very large-database coverage.