DBCC (Database Console Command)

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.

Informational statements

• DBCC INPUTBUFFER
• DBCC SHOWCONTIG
• DBCC OPENTRAN
• DBCC OUTPUTBUFFER
• DBCC PROCCACHE
• DBCC SHOW_STATISTICS
• DBCC SQLPERF
• DBCC TRACESTATUS
• DBCC USEROPTIONS

Validation statements

• DBCC CHECKALLOC
• DBCC CHECKCATALOG
• DBCC CHECKCONSTRAINTS
• DBCC CHECKDB
• DBCC CHECKFILEGROUP
• DBCC CHECKIDENT
• DBCC CHECKTABLE

Maintenance statements

• DBCC CLEANTABLE
• DBCC DBREINDEX
• DBCC DROPCLEANBUFFERS
• DBCC FREEPROCCACHE
• DBCC INDEXDEFRAG
• DBCC SHRINKDATABASE
• DBCC SHRINKFILE
• DBCC UPDATEUSAGE

Miscellaneous statements

• DBCC dllname (FREE)
• DBCC HELP
• DBCC FLUSHAUTHCACHE
• DBCC TRACEOFF
• DBCC FREESESSIONCACHE
• DBCC TRACEON
• DBCC FREESYSTEMCACHE
• DBCC CLONEDATABASE (Applies to: SQL Server 2014 (12.x) Service Pack 2 and later versions.)