Sample Queries

This section provides examples that illustrate using SYSCS_UTIL.SYSCS_CHECK_TABLE() in queries.

Check the consistency of a single table:

VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'FLIGHTS')

Check the consistency of all of the tables in a schema, stopping at the first failure:

SELECT tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(
    'SAMP', tablename)
FROM sys.sysschemas s, sys.systables t
WHERE s.schemaname = 'SAMP' AND s.schemaid = t.schemaid

Check the consistency of an entire database, stopping at the first failure:

SELECT schemaname, tablename,
SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname, tablename)
FROM sys.sysschemas s, sys.systables t
WHERE s.schemaid = t.schemaid