DBCC CHECKCATALOG

Transact-SQL Reference

Transact-SQL Reference

DBCC CHECKCATALOG

Checks for consistency in and between system tables in the specified database.

Syntax

DBCC CHECKCATALOG
    ( 'database_name'
    )
    [ WITH NO_INFOMSGS ]

Arguments

'database_name'

Is the database for which to check system table consistency. If not specified, the default is the current database. Database names must conform to the rules for identifiers. For more information, see Using Identifiers.

WITH NO_INFOMSGS

Suppresses all informational messages and the report of space used when there are less than 200 error messages. If not specified, DBCC CHECKCATALOG displays all error messages. DBCC CHECKCATALOG messages are sorted by object ID, except for those messages generated from tempdb.

Remarks

DBCC CHECKCATALOG checks that every data type in syscolumns has a matching entry in systypes and that every table and view in sysobjects has at least one column in syscolumns.

Result Sets

If no database is specified, DBCC CHECKCATALOG returns this result set (message):

DBCC results for 'current database'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

If Northwind is provided as a database name, DBCC CHECKCATALOG returns this result set (message):

DBCC results for 'Northwind'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Permissions

DBCC CHECKCATALOG permissions default to members of the sysadmin fixed server role, the db_owner and db_backupoperator fixed database roles, and are not transferable.

Examples

This example checks the allocation and structural integrity of objects in both the current database and in the pubs database.

-- Check the current database.
DBCC CHECKCATALOG
GO
-- Check the pubs database.
DBCC CHECKCATALOG ('pubs')
GO

See Also

DBCC

System Tables