Maintenance DBCC Commands

Maintenance DBCC statements are used to gather information about the general health of the database as well as specific database objects and to repair minor database corruption issues.

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

•DBCC DBREINDEX
•DBCC INDEXDEFRAG
•DBCC NEWALLOC
•DBCC SHOWCONTIG
•DBCC SHOW_STATISTICS
•DBCC SHRINK_DATABASE
•DBCC SHRINKFILE