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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Maintaining Your Database » Backup and data recovery » Backup and recovery tasks


Validating a single table

You can check the validity of a single table either from Sybase Central or using a SQL statement. 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)

  • Execute the VALIDATE TABLE statement:

    VALIDATE TABLE table-name;

If errors are reported, you can drop all of 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 to errors reported by VALIDATE TABLE is to unload and reload your entire database. You should use the dbunload -u option so that it does not try to use a possibly corrupt index to order the data.

For more information about using the REBUILD clause of the ALTER INDEX statement, see ALTER INDEX statement.