The Four Categories of DBCC Statements

Purpose: Use this job aid to familiarize yourself with the four categories of DBCC statements that can be used to maintain a SQL Server 2012 database.

The Transact-SQL programming language groups DBCC statements into four command categories:

• • informational

• validation

• maintenance, and

• miscellaneous