DBCC 命令参考

来源：互联网发布：idg联合校招知乎编辑：程序博客网时间：2024/05/21 17:41
快速参考
下表列举了常用的一些DBCC 命令的使用方法：
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 | {RESEED    [,new_reseed_value] } } ] )DBCC DBREINDEX (['database.owner.table_name' [, index_name    [, fillfactor ]]])[WITH NO_INFOMSGS]DBCC dllname (FREE)DBCC INPUTBUFFER (spid)DBCC OPENTRAN ({database_name} | {database_id}) [WITH TABLERESULTS]    [,NO_INFOMSGS]DBCC OUTPUTBUFFER (spid)DBCC PERFMONDBCC PINTABLE    (database_id, table_id)DBCC SHOW_STATISTICS    (table_name, index_name)DBCC SHOWCONTIG    (table_id, [index_id])DBCC SHRINKDATABASE (database_name [, target_percent]  [, {NOTRUNCATE    | TRUNCATEONLY} ])DBCC SHRINKFILE    (    {file_name | file_id }            {    [, target_size]            |    [, {EMPTYFILE | NOTRUNCATE | TRUNCATEONLY}]            }    )DBCC SQLPERF (LOGSPACE)DBCC TRACEOFF (trace# [,...N])DBCC TRACEON (trace# [,...N])DBCC TRACESTATUS (trace# [, trace#...])DBCC UNPINTABLE (database_id, table_id)DBCC UPDATEUSAGE    (    {'database_name' | 0}            [, 'table_name' [, index_id]            ]    )    [    WITH [COUNT_ROWS] [, NO_INFOMSGS ]        ]DBCC USEROPTIONS