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
