db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: determing index name
Date Thu, 15 Feb 2007 18:51:12 GMT
> Is there a way to get a list of indexes on a table including the index 
> name.  

This sounds like a nice enhancement request for 'show indexes'.

You could also try looking in sys.sysconglomerates.

   SELECT * FROM SYS.SYSCONGLOMERATES

seems to show me the index name, but of course you'll have to do a bit
of system catalog joining and querying to tie that back to your base table.

thanks,

bryan



Mime
View raw message