db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject SYSTEMALIAS flag in SYSALIASES table
Date Wed, 08 Mar 2006 19:31:38 GMT

I ran following query in a 10.2 db
select alias,systemalias from sys.sysaliases;

I was expecting to see true for systemalias column for Derby supplied
routines like SYSCS_COMPRESS_TABLE, SYSCS_EXPORT_TABLE etc. But all the rows
returned by the query above have systemalias set to false. According to the
docs on SYSALIASES table, the column systemalias will be set to true for
system supplief/built-in aliases. Is the doc incorrect, system table
incorrect or I am missing something?


View raw message