db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1547837 - /db/derby/docs/trunk/src/ref/rrefsyscsdiagspacetable.dita
Date Wed, 04 Dec 2013 16:29:21 GMT
Author: chaase3
Date: Wed Dec  4 16:29:20 2013
New Revision: 1547837

URL: http://svn.apache.org/r1547837
Log:
DERBY-6415  SYSCS_DIAG.SPACE_TABLE sample query to show all tables and indexes 
should include schema

Modified a Reference Manual topic.

Patch: DERBY-6415.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefsyscsdiagspacetable.dita

Modified: db/derby/docs/trunk/src/ref/rrefsyscsdiagspacetable.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscsdiagspacetable.dita?rev=1547837&r1=1547836&r2=1547837&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscsdiagspacetable.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscsdiagspacetable.dita Wed Dec  4 16:29:20 2013
@@ -126,14 +126,15 @@ the specified schema and table.</li>
 </table>
 <p>For example, use the following query to return the space usage for all of the
 user tables and indexes in the database:
-<codeblock>SELECT T2.*
+<codeblock>SELECT sysschemas.schemaname, T2.*
     FROM
-        SYS.SYSTABLES systabs,
+        SYS.SYSTABLES systabs, SYS.SYSSCHEMAS sysschemas,
         TABLE (SYSCS_DIAG.SPACE_TABLE()) AS T2
     WHERE systabs.tabletype = 'T'
+    AND sysschemas.schemaid = systabs.schemaid
     AND systabs.tableid = T2.tableid;</codeblock>
-where T2 is a user-specified
-table name that is any valid identifier. </p><p>Both the <parmname>schemaName</parmname>
and
+where T2 is a user-specified table name that is any valid identifier.</p>
+<p>Both the <parmname>schemaName</parmname> and
 the <parmname>tableName</parmname> arguments must be expressions whose data
 types map to Java strings. If the <parmname>schemaName</parmname> and the <parmname>tableName</parmname>
are
 non-delimited identifiers, you must specify the names in upper case.</p><p>For



Mime
View raw message