[jira] [Created] (DERBY-6415) SYSCS_DIAG.SPACE_TABLE sample query to show all tables and indexes should include schema

["Kathey Marsden (JIRA)" <ji...@apache.org>]

Kathey Marsden created DERBY-6415:
-------------------------------------

             Summary: 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
            Priority: Trivial


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)