Icon VERIFY TABLE

Verifies a table to see if any corruption exists in the table.

Syntax
VERIFY TABLE <TableName>
[STRUCTURE ONLY]

Usage
Use this statement to verify the specified table.

The STRUCTURE ONLY clause can be used to specify that ElevateDB should only do a structural scan, and not actually examine the contents of rows for more in-depth corruption checks. Using this clause can improve the performance of a table verification greatly, but does not guarantee that the row contents are not possibly still corrupted. Usually the best practice is to first execute the VERIFY TABLE statement on the specified table with the STRUCTURE ONLY clause. If the VERIFY TABLE execution indicates any corruption at all, then you should execute the REPAIR TABLE statement on the specified table without the STRUCTURE ONLY clause so that the table is exhaustively repaired.

You can use the STMTRESULT function to retrieve the result of a table verification in any procedure, function, script, or job. For retrieving the result of a table verification from a client application, please see your compiler-specific manual for retrieving the result of a statement exectuion.

The VERIFY TABLE statement requires a read lock on the specified table during its execution.

Examples
VERIFY TABLE Orders

Required Privileges
The current user must be granted the MAINTAIN privilege on the current database in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension.
Image