Help and syntax information for DBCC commands.
Syntax
      DBCC HELP ('dbcc_command') [WITH NO_INFOMSGS ]
      DBCC HELP (@dbcc_command_var) [WITH NO_INFOMSGS ]
      DBCC HELP ('?')  [WITH NO_INFOMSGS ]
Key:
   WITH NO_INFOMSGS - Suppress all information messages (severity levels 0-10)
   dbcc_command     - The DBCC 'xyz' command
Examples
DBCC HELP ('?')
GO
DBCC HELP ('USEROPTIONS')
GO
DECLARE @help_var sysname
   SET @help_var = 'CHECKALLOC'
   DBCC HELP (@help_var)
 GO
"It is our special duty, that if anyone needs our help, we should give him such help to the utmost of our power" ~ Cicero
Equivalent Oracle command: HELP topic - In SQL*Plus