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.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1