Check Tables

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you issue a CHECK TABLE statement, checking one or more tables for errors. This operation returns a standard CHECK TABLE result set. Each returned message consists of Table (name), Op (with a value of CHECK), Msg_type (STATUS, ERROR, INFO, WARNING), and Msg_text components.

Platform Availability

To Check a Table for Errors

  1. Initiate a Check Tables action against one or more tables. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in this wizard:
Step Settings and tasks

Action Options


Only check tables that have changed since the last check.


Perform a full key lookup for all keys in each row.


Check only tables that have not been properly closed.


Scan rows to verify that deleted links are valid. Calculate a key checksum for the rows and verify using a calculated checksum for keys.


Perform a full key lookup for all keys in each row.


Displays the DDL that will execute the object action. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.

The results set opens on the Results tab of an ISQL editor window. For more information, see Using the Results Editor.