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

Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2013/10/23 00:25:42 UTC

[Db-derby Wiki] Trivial Update of "ListFileNamesOfTables" by MyrnavanLunteren

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The "ListFileNamesOfTables" page has been changed by MyrnavanLunteren:
https://wiki.apache.org/db-derby/ListFileNamesOfTables?action=diff&rev1=5&rev2=6

  
  {{{
  select  CAST(TABLENAME as varchar(32)) as DB_table, CAST('C' ||  bigintToHexString
- (CONGLOMERATENUMBER)  ||  '.dat'as varchar(12)) as file , isindex
+ (CONGLOMERATENUMBER)  ||  '.dat' as varchar(12)) as file, isindex
   from SYS.SYSCONGLOMERATES a, SYS.SYSTABLES b
   where a.TABLEID = b.TABLEID AND b.TABLETYPE <> 'S' 
  order by file;