dbcc-help-transact-sql.md

description	DBCC HELP (Transact-SQL)
title	DBCC HELP (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	07/16/2017
ms.prod	sql
ms.prod_service	sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	DBCC HELP DBCC_HELP_TSQL
dev_langs	TSQL
helpviewer_keywords	DBCC statement syntax information DBCC HELP statement
ms.assetid	306092c6-4354-4e47-928b-606124fbdc6e
author	pmasl
ms.author	umajay

DBCC HELP (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Returns syntax information for the specified DBCC command.

Transact-SQL Syntax Conventions

Syntax

DBCC HELP ( 'dbcc_statement' | @dbcc_statement_var | '?' )  
[ WITH NO_INFOMSGS ]  

[!INCLUDEsql-server-tsql-previous-offline-documentation]

Arguments

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.

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

Result Sets

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

Permissions

Requires membership in the sysadmin fixed server role.

Examples

A. Using DBCC HELP with a variable

The following example returns syntax information for DBCC CHECKDB.

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

B. Using DBCC HELP with the ? option

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

DBCC HELP ('?');  
GO  

See Also

DBCC (Transact-SQL)