dbcc checkcatalog checks for consistency within and between the system tables in a database. For example, it verifies that:
Every type in syscolumns has a matching entry in systypes.
Every table and view in sysobjects has at least one column in syscolumns.
sysindexes is consistent and fixes any errors
For each row in syspartitions, there exists a matching row in sysegments.
The last checkpoint in syslogs is valid.
It also lists the segments defined for use by the database and fixes any errors it finds.
The syntax for dbcc checkcatalog is:
dbcc checkcatalog [(database_name [, fix])]
If you do not specify a database name, dbcc checkcatalog checks the current database.
dbcc checkcatalog (testdb)
Checking testdb The following segments have been defined for database 5 (database name testdb). virtual start addr size segments -------------------- ------ -------------------------- 33554432 4096 0 1 16777216 102 2 DBCC execution completed. If DBCC printed error messages, see your System Administrator.
