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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Maintaining Your Database » Validating databases » Using checksums to detect corruption


Validate a table

You must have either DBA or VALIDATE authority to validate a table.

To check the validity of a table (Sybase Central)
  1. Connect to the database as a user with DBA authority.

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

  3. Right-click the table and choose Validate.

  4. Click OK.

To check the validity of a table (SQL)
  • 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.