Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Database validation » Corruption detection using checksums

 

Validating a table

You can validate a table using Sybase Central.

Prérequis

You must have the VALIDATE ANY OBJECT system privilege. It is best to validate when there is no other activity on the table.

Contexte et remarques

  • If errors are reported, you can drop all the indexes and keys on a table and recreate them. Any foreign keys to the table also need to be recreated.

  • If you suspect a particular index, you can execute an ALTER INDEX...REBUILD statement to rebuild the corrupted index.

  • Another solution for errors reported by the VALIDATE TABLE statement is to unload and reload your entire database. You should use the dbunload -u option so that the unload process does not try to use a possibly corrupt index to order the data.

 Task
  1. Use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, double-click Tables.

  3. Right-click the table and click Validate.

  4. Click OK.

Résultat

The table is validated.

 See also