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.

Syntax

sa_validate(
[ tbl_name
[, owner_name
[, check_type ] ] ]
)

Arguments
Permissions

DBA authority required

Side effects

None

Remarks

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.

Caution    

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.

Example

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

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