Checking Consistency of Individual Tables

Use

You might suspect that a table is no longer physically consistent, due to entries in the error log. In this case, you can check the table on its own, without examining the consistency of the entire database.

Note

When the consistency of a table is checked, a shared table lock is held on the table.

Procedure

Access the DBA Cockpit with transaction DBACOCKPIT and navigate to Space → Single Table Analysis.
Enter the name of the table you want to check and choose Refresh.
Information about the table is displayed.
Choose DBCC checktable , and click on the DBCC checktable button to start the table analysis.
The results of the analysis are shown on the screen. All the error messages that were generated during the check are displayed.