Transact-SQL Programming Language - DBCC Statements

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.

Statement Category

Perform

Maintenance Statements	Maintenance tasks on a database, index, or filegroup.
Miscellaneous Statements	Miscellaneous tasks such as enabling row-level locking or removing a dynamic-link library (DLL) from memory.
Status statements	Status checks.
Validation Statements	Validation operations on a database, table, index, catalog, filegroup, system tables, or allocation of database pages.

Maintenance Statements

DBCC DBREPAIR	DBCC SHRINKFILE
DBCC DBREINDEX	DBCC UPDATEUSAGE
DBCC SHRINKDATABASE

Miscellaneous Statements

DBCC dllname (FREE)	DBCC TRACEOFF
DBCC HELP	DBCC TRACEON
DBCC PINTABLE	DBCC UNPINTABLE
DBCC ROWLOCK

Status Statements

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

Validation Statements

DBCC CHECKALLOC	DBCC CHECKTABLE
DBCC CHECKCATALOG	DBCC NEWALLOC
DBCC CHECKDB	DBCC TEXTALL
DBCC CHECKFILEGROUP	DBCC TEXTALLOC
DBCC CHECKIDENT

Last Updated: Thursday April 01, 1999
All trademarks or product names mentioned herein are the property of their respective owners.

If you would like additional information about this page, please e-mail [email protected].