db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Trivial Update of "ListFileNamesOfTables" by MyrnavanLunteren
Date Tue, 22 Oct 2013 22:25:42 GMT
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;

Mime
View raw message