![]() |
Checking Database Consistency
|
|
Sample QueriesThis section provides examples that illustrate using checkTable in queries. Check the consistency of a single table: VALUES ConsistencyChecker.checkTable('APP', 'FLIGHTS') Check the consistency of all of the tables in a schema, stopping at the first failure:
SELECT tablename, ConsistencyChecker.checkTable( Check the consistency of an entire database, stopping at the first failure:
SELECT schemaname, tablename, NOTE: See the sample program JBMSTours.AdminHelper for an example of running the consistency checker. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |