Checking consistency of system tables

dbcc checkcatalog checks for consistency within and between the system tables in a database. For example, it verifies that:

It also lists the segments defined for use by the database.

The syntax for dbcc checkcatalog is:

dbcc checkcatalog [(database_name)]

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.