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
