Introduction

---

The SQL VERIFY TABLE statement is used to verify a table and make sure that there is no corruption in the table.

Syntax

---

VERIFY TABLE [IF EXISTS] table_reference

Use the VERIFY TABLE statement to verify the physical structure of a table to make sure that it is not corrupted. The statement below verifies a table:

VERIFY TABLE Employee

You can use the REPAIR TABLE SQL statement to repair a table that is determined to be corrupted via the VERIFY TABLE statement.

Please see the Verifying and Repairing Tables topic for more information on verifying tables.