You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ch...@apache.org on 2013/12/04 17:29:21 UTC
svn commit: r1547837 -
/db/derby/docs/trunk/src/ref/rrefsyscsdiagspacetable.dita
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