DBCC CHECKDB - Check the allocation, and integrity of all objects in a database.

Syntax
      DBCC CHECKDB 
      [( 'database' | database_id | 0
      [ , NOINDEX
      {REPAIR_ALLOW_DATA_LOSS |
              REPAIR_FAST |
              REPAIR_REBUILD}
      )]
       [WITH
        {
        [ALL_ERRORMSGS ] [ , NO_INFOMSGS ] [ , TABLOCK ]
            [, ESTIMATEONLY ] [ , { PHYSICAL_ONLY | DATA_PURITY } ]
        }
      ]
                  
 Key:
   NOINDEX        - Skip intensive checks of nonclustered indexes for user tables
   REPAIR_ALLOW_DATA_LOSS - Try to repair all reported errors.
   REPAIR_REBUILD - Perform all repairs that can be performed without risk of data loss.
   ALL_ERRORMSGS  - Return all reported errors per object, default = first 200 errors.
   TABLOCK        - Obtain locks instead of using an internal database snapshot. 
                    this limits the checks that are performed.
   ESTIMATEONLY   - Display the estimated amount of tempdb space that would be required.
   PHYSICAL_ONLY  - Limits the checking to the integrity of the physical structure
   DATA_PURITY    - Check the database for column values that are not valid or out-of-range.

Examples

-- Check the current database.
DBCC CHECKDB;
GO

"There are moments when everything goes well; don’t be frightened, it won’t last” ~ Jules Renard

Related commands

Brian Cryer How To - Run DBCC checkdb on each database (using cursors)