The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server.
Database Console Command statements are grouped into the following categories.
DBCC commands take input parameters and return values. All DBCC command parameters can accept both Unicode and DBCS literals.
Some of the Maintenance DBCC Statements are:
Some of the Miscellaneous DBCC Statements are:
DBCC dllname (FREE)
Some of the Informational DBCC Statements are:
Some of the Validation DBCC Statements are:
Some of the useful DBCC commands along with their syntax and examples are listed down and are available for download. Click here to download your copy now.