Check Tables

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

• MySQL

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	Changed	Only check tables that have changed since the last check.
	Extended	Perform a full key lookup for all keys in each row.
	Fast	Check only tables that have not been properly closed.
	Medium	Scan rows to verify that deleted links are valid. Calculate a key checksum for the rows and verify using a calculated checksum for keys.
	Quick	Perform a full key lookup for all keys in each row.
Preview	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.