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

SQL Anywhere 12.0.0 (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. Use the SQL Anywhere 12 plug-in to 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;
 Notes