[
https://issues.apache.org/jira/browse/DERBY-6415?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13839146#comment-13839146
]
ASF subversion and git services commented on DERBY-6415:
--------------------------------------------------------
Commit 1547864 from [~chaase3] in branch 'docs/branches/10.10'
[ https://svn.apache.org/r1547864 ]
DERBY-6415 SYSCS_DIAG.SPACE_TABLE sample query to show all tables and indexes
should include schema
Merged DERBY-6415.diff to 10.10 doc branch from trunk revision 1547837.
> SYSCS_DIAG.SPACE_TABLE sample query to show all tables and indexes should
> include schema
> ----------------------------------------------------------------------------------------
>
> Key: DERBY-6415
> URL: https://issues.apache.org/jira/browse/DERBY-6415
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.10.1.1
> Reporter: Kathey Marsden
> Assignee: Kim Haase
> Priority: Trivial
> Attachments: DERBY-6415.diff, rrefsyscsdiagspacetable.html
>
>
> It would be good if the sample query for SYSCS_DIAG.SPACE_TABLE also showed
> the schema name as that will be required by SYSCS_UTIL.SYSCS_COMPRESS_TABLE
> if the tables are compressed.
> The doc page as at:
> http://db.apache.org/derby/docs/10.10/ref/rrefsyscsdiagspacetable.html
> The query for all tables and indexes could be:
> SELECT sysschemas.schemaname, T2.*
> FROM
> 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;
--
This message was sent by Atlassian JIRA
(v6.1#6144)
