Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DBCC HELP (Transact-SQL)

DBCC HELP (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns syntax information for the specified DBCC command.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

DBCC HELP ( 'dbcc_statement' | @dbcc_statement_var | '?' )

dbcc_statement | @dbcc_statement_var

Is the name of the DBCC command for which to receive syntax information. Provide only the part of the DBCC command that follows DBCC, for example, CHECKDB instead of DBCC CHECKDB.


Returns all DBCC commands for which Help is available.


Suppresses all informational messages that have severity levels from 0 through 10.

DBCC HELP returns a result set displaying the syntax for the specified DBCC command.

Requires membership in the sysadmin fixed server role.

The following example returns syntax information for DBCC CHECKDB.

DECLARE @dbcc_stmt sysname;
SET @dbcc_stmt = 'CHECKDB';
DBCC HELP (@dbcc_stmt);

The following example returns all DBCC statements for which Help is available.

DBCC HELP ('?');

Community Additions

© 2015 Microsoft