[DERBY-1209] It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.1.3.1, 10.2.1.6
• Fix Version/s: 10.5.2.0, 10.6.1.0
• Component/s: Documentation
• Urgency: Urgent
• Issue & fix info: Newcomer, Patch Available
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 13/Apr/06 08:36
• Updated: 12/Jan/11 22:24
• Resolved: 13/Jul/09 18:23

Description

It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation on how to check all tables:
http://db.apache.org/derby/docs/10.1/ref/rrefsyscschecktablefunc.html

e.g.

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