Use this statement to validate a database using checksums.
VALIDATE CHECKSUM
Ensures that database pages have not been modified on disk. When a database is created with checksums enabled, a checksum is calculated for each database page before it is written to disk. VALIDATE CHECKSUM reads each database page from disk and calculates the checksum for each page. If the calculated checksum for a page does not match the stored checksum for that page, an error occurs and information about the invalid page appears in the server messages window.
This type of validation can only be used on databases that were created with checksums enabled. You can check whether a database has checksums enabled by executing the following statement:
SELECT db_property ( 'Checksum' )
None
None
SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.