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

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 10.10.1.1
• Fix Version/s: 10.10.2.0, 10.11.1.1
• Component/s: Documentation
• Assignee: Camilla Haase
• Reporter: Katherine Marsden
• Created: 12/Nov/13 18:48
• Updated: 21/Jan/15 00:23
• Resolved: 04/Dec/13 18:10

Description

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;