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)
