db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Index Names
Date Mon, 25 Feb 2008 13:55:27 GMT
Chris wrote:
> I'm wanting to drop a row/record/index in my Derby Embedded 
> installation (pre-installed in ColdFusion 8 Developer's Edition), but 
> the index-names aren't as simple as I had originally assumed (0, 1, 
> 2,...).  I visited 
> http://db.apache.org/derby/docs/10.3/ref/rrefsqlj59893.html to 
> understand them, but it doesn't tell me how to determine what my 
> indexes are named.  I haven't renamed them, so what's the default 
> name, and how do I alter that name to obtain the Nth index?
>
> Thanks!
> Chris
Hi Chris,

The following query will list out the names of all the indexes in the 
database:

select t.tablename, c.conglomeratename
from sys.systables t, sys.sysconglomerates c
where c.isindex and t.tableid = c.tableid
order by tablename, conglomeratename

Hope this helps,
-Rick

Mime
View raw message