DBCC

DBCC stood for Database Console Command (Database Consistency Checker prior to SQL2000). It's now divides into four categories: validation, maintenance, informational, and miscellaneous.

To get a list of all the DBCC commands: DBCC help ('?')

To get syntax help with a particular DBCC command: DBCC help ('checkdb')

The Validation commands are the CHECK commands:

DBCC CHECKTABLE
DBCC CHECKDB
DBCC CHECKALLOC
DBCC CHECKFILEGROUP
DBCC CHECKCATALOG
DBCC CHECKCONSTRAINT
DBCC CHECKIDENT

The Informational commands are:

DBCC IND
DBCC PAGE (you need to turn on trace flag 3604 to see the output. DBCC TRACEON(3604) )