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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database maintenance » Database validation » Corruption detection using checksums


Validating a table

 Check the validity of a table (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or VALIDATE authority.

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

  3. Right-click the table and click Validate.

  4. Click OK.

 Check the validity of a table (SQL)
  1. Connect to the database as a user with DBA or VALIDATE authority.

  2. Execute the VALIDATE TABLE statement:

    VALIDATE TABLE table-name;
  • 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. See ALTER INDEX statement.

  • Another solution for errors reported by VALIDATE TABLE 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.