Syntax DBCC CHECKTABLE ('table' | 'view' [ , { NOINDEX | index_id } |, { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ] ) [WITH { ALL_ERRORMSGS ] [ , EXTENDED_LOGICAL_CHECKS ] [ , NO_INFOMSGS ] [ , TABLOCK ] [ , ESTIMATEONLY ] [ , { PHYSICAL_ONLY | DATA_PURITY } ] } ] Key: NOINDEX - Skip intensive checks of nonclustered indexes. REPAIR_ALLOW_DATA_LOSS - Try to repair all reported errors. REPAIR_REBUILD - Perform all repairs that can be performed without risk of data loss. REPAIR_FAST - deprecated option ALL_ERRORMSGS - Return all reported errors per object, default = first 200 errors. TABLOCK - Obtain locks instead of using an internal database snapshot. ESTIMATEONLY - Display the estimated amount of tempdb space that would be required. PHYSICAL_ONLY - Limits the checking to the integrity of the physical structure EXTENDED_LOGICAL_CHECKS - If the compatibility level is 100 (SQL Server 2008) or higher, perform logical consistency checks on indexed views, XML indexes, and spatial indexes. DATA_PURITY - Check the table for column values that are not valid or out-of-range.
Use the DATA_PURITY option for databases upgraded from versions of SQL Server earlier than 2005.
To repair errors restore from a backup, use the REPAIR options only as a last resort.
-- Check the integrity of MyTable in 'MyDatabase' USE MyDatabase;
GO
DBCC CHECKTABLE ('MySchema.MyTable')
GO
"We're going to rebuild and rebuild stronger” ~ Mayor Rudolph Giuliani
DBCC CHECKCONSTRAINTS - Check integrity of table constraints.