0 What are DBCC COMMANDS? (SQL)

The Transact-SQL programming language provides DBCC statements that act as the “database consistency checker” for Microsoft® SQL Server™. These statements check the physical and logical consistency of a database. Many DBCC statements can fix detected problems. These database consistency-checking statements are grouped into these categories.

Maintenance Statements:
Maintenance tasks on a database, index, or filegroup.

1. DBCC DBREPAIR
2. DBCC SHRINKFILE
3. DBCC DBREINDEX
4. DBCC UPDATEUSAGE
5. DBCC SHRINKDATABASE

Miscellaneous Statements:
Miscellaneous tasks such as enabling row-level locking or removing a dynamic-link library (DLL) from memory

1. DBCC dllname (FREE)
2. DBCC TRACEOFF
3. DBCC HELP
4. DBCC TRACEON
5. DBCC PINTABLE
6. DBCC UNPINTABLE
7. DBCC ROWLOCK

Status Statements:
Status Checks

1. DBCC INPUTBUFFER
2. DBCC SHOW_STATISTICS
3. DBCC OPENTRAN
4. DBCC SQLPERF
5. DBCC OUTPUTBUFFER
6. DBCC TRACESTATUS
7. DBCC PROCCACHE
8. DBCC USEROPTIONS
9. DBCC SHOWCONTIG

Validation Statements:
Validation operations on a database, table, index, catalog, filegroup, system tables, or allocation of database pages.

1. DBCC CHECKALLOC
2. DBCC CHECKTABLE
3. DBCC CHECKCATALOG
4. DBCC NEWALLOC
5. DBCC CHECKDB
6. DBCC TEXTALL
7. DBCC CHECKFILEGROUP
8. DBCC TEXTALLOC
9. DBCC CHECKIDENT