You must have either DBA or VALIDATE authority to validate a table.
Connect to the database as a user with DBA authority.
In the left pane, double-click Tables.
Right-click the table and choose Validate.
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.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|