db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: determing index name
Date Thu, 15 Feb 2007 19:44:29 GMT
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.


View raw message