On 20.01.12 03:49, ollie2308 wrote:
Hi
I am having trouble writing a query that uses the derby system tables to
return all index names and the columns and their order that make up the
indexes.
Hi,
I'm not sure if we have a good solution for this.
You may find the information at [1] helpful, but to me it looks like
you'll have to parse the value of the column DESCRIPTOR in
SYS.SYSCONGLOMERATES to get what you want.
Regards,
--
Kristian
[1] http://wiki.apache.org/db-derby/ListKeyIndexes
Any help would be appreciated.
Thanks