Check Tables

Access this form by selecting a database node in the navigation pane and clicking the check tables icon on the toolbar.

Select tables
Select the tables you want to check.

Options

Check all/don't repair
Specify if you want to check the data in the selected tables against all constraints or only those constraints that are active.

Check data only (don't check indexes)
Specifies that non-clustered indexes for non-system tables should not be checked.

Check all and repair errors
Specifies that the operation repair the found errors.

The database must be in single-user mode to use a repair option.

Fast repair	Performs minor, non time-consuming repair actions such as repairing extra keys in non-clustered indexes. These repairs can be done quickly and without risk of data loss.
Repair and rebuild indexes	Performs all repairs done by Fast repair and includes time-consuming repairs such as rebuilding indexes. These repairs can be done without risk of data loss.
Complete (allow data loss)	Performs all repairs done by Repair and rebuild indexes and includes allocation and de-allocation of rows and pages for correcting allocation errors, structural row or page errors, and deletion of corrupted text objects. These repairs can result in some data loss. After repairs are completed, back up the database.

Obtain shared table lock
Causes the operation to obtain a shared table lock.

Physical check only
Limits the checking to the integrity of the physical structure of the page and record headers, and to the consistency between the pages' object ID and index ID and the allocation structures. Designed to provide a low overhead check of the physical consistency of the database, this check also detects torn pages and common hardware failures that can compromise a user's data.

Estimate required tempdb space only
Displays the estimated amount of tempdb space needed to run the operation with all of the other specified options.

Check Now
Begin checking the table data.

Results
Displays the results of checking the data.