DBCC HELP

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