Randy Letness wrote:
Is there a way to get a list of indexes on a table including the index
name. I tried using "show indexes", but it doesn't give the index
name, just the columns that are indexed. The use case is that i have
an existing db and want to drop an index, but i don't know the name of
the index.
-Randy
The Apache Wiki has a query that lists the primary and foreign key
indexes. You might be able to modify this for also include non-key indexes.
http://wiki.apache.org/db-derby/ListKeyIndexes
