DBCC CHECKCATALOG

Check for catalog consistency

Syntax
     DBCC CHECKCATALOG 
        [('database_name' | database_id | 0 )]
           [WITH NO_INFOMSGS]

 Key:
   WITH NO_INFOMSGS - Suppresses all informational messages.
   database_name | database_id | 0   The name or ID of the database for which to check catalog consistency.
   If not specified, or if 0 is specified, the current database is used. 

“The quality of a department is inversely proportional to the number of courses it lists in its catalogue” ~ Hildebrand's Law

Related commands

DBCC CHECKTABLE - Check integrity of a table or indexed view.