Checking Database and Table Consistency

The dbcc commands for checking the consistency of databases and tables are dbcc checkstorage, dbcc checktable, dbcc checkindex, and dbcc checkdb.

• dbcc checkstorage
  dbcc checkstorage runs checks against the database on disk.
• dbcc checktable
  dbcc checktable performs a series of checks on the specified table.
• dbcc checkindex
  dbcc checkindex runs the same checks as dbcc checktable, but only on the specified index instead of the entire table.
• dbcc checkdb
  dbcc checkdb runs the same checks as dbcc checktable on each table in the specified database.