svn commit: r793647 - /db/derby/docs/branches/10.5/src/ref/rrefsyscschecktablefunc.dita

[km...@apache.org]

Author: kmarsden
Date: Mon Jul 13 18:21:40 2009
New Revision: 793647

URL: http://svn.apache.org/viewvc?rev=793647&view=rev
Log:
DERBY-1209 It would be good to add an example to the SYSCS_UTIL.SYSCS_CHECK_TABLE documentation for how to check all tables


Modified:
    db/derby/docs/branches/10.5/src/ref/rrefsyscschecktablefunc.dita

Modified: db/derby/docs/branches/10.5/src/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.5/src/ref/rrefsyscschecktablefunc.dita?rev=793647&r1=793646&r2=793647&view=diff
==============================================================================
--- db/derby/docs/branches/10.5/src/ref/rrefsyscschecktablefunc.dita (original)
+++ db/derby/docs/branches/10.5/src/ref/rrefsyscschecktablefunc.dita Mon Jul 13 18:21:40 2009
@@ -28,7 +28,16 @@
 <section><title>Syntax</title> <codeblock>SMALLINT SYSCS_UTIL.SYSCS_CHECK_TABLE(IN SCHEMANAME VARCHAR(128),
 IN TABLENAME VARCHAR(128)) </codeblock> <p>An error will occur if either SCHEMANAME
 or TABLENAME are null.</p></section>
-<section><title>Example</title> <codeblock>VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('SALES', 'ORDERS');</codeblock></section>
+<section><title>Examples</title> 
+Check a single table:
+<codeblock>VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('SALES', 'ORDERS');</codeblock>
+Check all tables:
+<codeblock>SELECT schemaname, tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(schemaname,
+tablename) FROM sys.sysschemas s, sys.systables t WHERE s.schemaid =
+t.schemaid;
+</codeblock>
+
+</section>
 </refbody>
 </reference>