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

SQL Anywhere 11.0.1 (Français) » 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)
Notes
  • 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.