DBCC CHECKTABLE verifies the integrity of all the pages and structures that makes the table or indexed view.
Syntax:
DBCC CHECKTABLE
(
table_name | view_name
[ , { NOINDEX | index_id }
|, { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD }
]
)
Before issuing Repair,take a backup of it.We can issue this command on all the tables in a database using DBCC CHECKDB command.We must be the owner of the table or member of the sysadmin,db_owner,db_ddladmin fixed database roles.