Memorizing DBCC commands (or any command for that matter) can be difficult if you don’t use it often. Thank goodness for the folks at Microsoft for creating the DBCC HELP command. Below is a quick way to use DBCC HELP to figure out any command (with syntax) that might have slipped your mind.
First, run DBCC HELP(‘?’) to display a list of available DBCC commands (see image below).
Second, replace the ‘?’ with whatever DBCC command you want help on. For example, let’s use “checkdb.” Once you run DBCC HELP(checkdb) you get a printout of the CHECKDB syntax. (see image below)