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.

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

Related

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