[
https://issues.apache.org/jira/browse/DERBY-1209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kathey Marsden updated DERBY-1209:
----------------------------------
Issue & fix info: [Newcomer, Patch Available] (was: [Newcomer])
> It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE
> documentation for how to check all tables
> ----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1209
> URL: https://issues.apache.org/jira/browse/DERBY-1209
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6
> Reporter: Kathey Marsden
> Assignee: Kathey Marsden
> Priority: Minor
> Attachments: derby-1209_diff.txt, rrefsyscschecktablefunc.html
>
>
> 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;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.