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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_unload_cost_model system procedure Next Page

sa_validate system procedure

Validates all tables in a database.


[ tbl_name
[, owner_name
[, check_type ] ] ]


DBA authority required

Side effects



This procedure is equivalent to calling the VALIDATE TABLE statement for each table in the database. See VALIDATE statement.

All of the values for the tbl_name, owner_name, and check_type arguments are strings and they must be enclosed in quotes.

The procedure returns a single column, named Messages. If all tables are valid, the column contains No error detected.


Validating a table or an entire database should be performed while no connections are making changes to the database; otherwise, spurious errors may be reported indicating some form of database corruption even though no corruption actually exists.


The following statement performs an express check on tables owned by DBA:

CALL sa_validate( owner_name = 'DBA', check_type = 'checksum' );