db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <kristian.waa...@oracle.com>
Subject Re: List columns that make up an index
Date Fri, 20 Jan 2012 07:23:33 GMT
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
>
>


Mime
View raw message