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.


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.

  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.


The table is validated.

 See also