Usage of DBCC CHECKTABLE

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.
Ebook Download
View all
Learn
View all