You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by tdempewolf <td...@gmail.com> on 2014/11/18 23:06:04 UTC

Re: a command to show table file-size?

Here is one which is very handy:

select v.*
from SYS.SYSSCHEMAS s,
SYS.SYSTABLES t,
new org.apache.derby.diag.SpaceTable(SCHEMANAME,TABLENAME) v
where s.SCHEMAID = t.SCHEMAID;

http://www.docjar.com/docs/api/org/apache/derby/diag/SpaceTable.html



--
View this message in context: http://apache-database.10148.n7.nabble.com/a-command-to-show-table-file-size-tp101717p143236.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.