db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r790433 - /db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita
Date Thu, 02 Jul 2009 01:49:12 GMT
Author: kmarsden
Date: Thu Jul  2 01:49:12 2009
New Revision: 790433

URL: http://svn.apache.org/viewvc?rev=790433&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/trunk/src/ref/rrefsyscschecktablefunc.dita

Modified: db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita?rev=790433&r1=790432&r2=790433&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscschecktablefunc.dita Thu Jul  2 01:49:12 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