Re: List columns that make up an index

2012-01-23 Thread Knut Anders Hatlen
Bryan Pendleton bpendleton.de...@gmail.com writes: What root canal Just to get column names of an index I always just use ij's show indexes command. http://db.apache.org/derby/docs/10.8/tools/rtoolsijcomrefshow.html Alternatively, from a Java application, this information can be

Re: List columns that make up an index

2012-01-21 Thread Bryan Pendleton
What root canal Just to get column names of an index I always just use ij's show indexes command. http://db.apache.org/derby/docs/10.8/tools/rtoolsijcomrefshow.html thanks, bryan

Re: List columns that make up an index

2012-01-20 Thread ollie2308
-that-make-up-an-index-tp33171994p33177395.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: List columns that make up an index

2012-01-19 Thread Kristian Waagan
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]