Quick Reference

A quick syntax reference for DBCC commands is shown in Listing B.1.

Listing B.1. Command
DBCC CHECKALLOC 
( 'database_name'
[, NOINDEX
|
{ REPAIR_ALLOW_DATA_LOSS
| REPAIR_FAST
| REPAIR_REBUILD
}]
) [WITH {ALL_ERRORMSGS | NO_INFOMSGS}]

DBCC CHECKCATALOG [(database_name)] [WITH NO_INFOMSGS]

DBCC CHECKTABLE
    (    'table_name'
            [,     NOINDEX
                | index_id
                |    {    REPAIR_ALLOW_DATA_LOSS
                        | REPAIR_FAST
                        | REPAIR_REBUILD
                    }]
    ) [WITH {ALL_ERRORMSGS | NO_INFOMSGS}]

DBCC CHECKDB
    (    'database_name'
            [,     NOINDEX
                |     {    REPAIR_ALLOW_DATA_LOSS
                        | REPAIR_FAST
                        | REPAIR_REBUILD
                    }]
    ) [WITH {ALL_ERRORMSGS | NO_INFOMSGS}]

DBCC CHECKFILEGROUP
    (    [{'filegroup' | filegroup_id}] [, NOINDEX]
    ) [WITH {ALL_ERRORMSGS | NO_INFOMSGS}]

DBCC CHECKIDENT [(table_name)] [, { NORESEED | ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial