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.