You can validate a table using Sybase Central.
You must have the VALIDATE ANY OBJECT system privilege. It is best to validate when there is no other activity on the table.
Context and remarks
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.
Another solution for errors reported by the VALIDATE TABLE statement 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.
Use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, double-click Tables.
Right-click the table and click Validate.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|