| Write some information about DBCC CHECKTABLE
With the help of DBCC CHECKTABLE we will check the consistency, corruption or indexed view in user define table in user define database. Now questions arise why we use DBCC CHECKTABLE when we have DBCC CHECKDB. We generally used DBCC CHECKTABLE for larger tables when we have not sufficient time to check for full database check(DBCC CHECKDB). Or we use DBCC CHECKTABLE when we have done correction of corruption in any sql table. And it is prudent to run DBCC CHECKDB to ensure there is not corruption on every object after corrective measures have been taken to correct database corruption.
So DBCC CHECKTABLE command performs the same operations as the DBCC CHECKDB command for a table in the database. Below are the most common uses of DBCC CHECKTABLE:-
(1)Consistency Check
(2)Consistency Check With NOINDEX
(3)Correct Errors With REPAIR_REBUILD
(4)Correct Errors With REPAIR_ALLOW_DATA_LOSS
(5)Logical Consistency Check For Indexed view, XML index, and Spatial Indexes
(6)Consistency Check With Lock
(7)Calculate Necessary Space For Consistency Check
(8)Only PHYSICAL Consistency Check
(9)DATA_PURITY Option
(10)DBCC CHECKTABLE For an Index | | |