db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Army <qoz...@gmail.com>
Subject Re: determing index name
Date Thu, 15 Feb 2007 19:07:37 GMT
Bryan Pendleton wrote:
>> Is there a way to get a list of indexes on a table including the index 
>> name.  
> 
> 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.

Or you can let dblook do the joining for you:

   java org.apache.derby.tools.dblook jdbc:derby:myDB -t myTable -verbose

That will list all of the DDL that relates to "myTable" in "myDB"--including the 
DDL for creating indexes on the table.  And yes, that includes index names :)

Army


Mime
View raw message