---
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](../../includes/applies-to-version/sql-asdbmi.md)]

Returns syntax information for the specified DBCC command.
  
![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
  
## Syntax  
  
```syntaxsql
DBCC HELP ( 'dbcc_statement' | @dbcc_statement_var | '?' )  
[ WITH NO_INFOMSGS ]  
```  
  
[!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)]

## 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`.
  
```sql  
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.
  
```sql  
DBCC HELP ('?');  
GO  
```  
  
## See Also  
[DBCC (Transact-SQL)](../../t-sql/database-console-commands/dbcc-transact-sql.md)