db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r793647 - /db/derby/docs/branches/10.5/src/ref/rrefsyscschecktablefunc.dita
Date Mon, 13 Jul 2009 18:21:41 GMT
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>
 



Mime
View raw message