db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris <jesdisci...@gmail.com>
Subject Re: Index Names
Date Mon, 25 Feb 2008 23:59:46 GMT
Thanks Rick!  I found out elsewhere that I wanted to DELETE rather than
DROP.  Could I get an explanation of what and index is?  I thought it was
like an array index in programming languages...

Thanks!
Chris

On Mon, Feb 25, 2008 at 7:55 AM, Rick Hillegas <Richard.Hillegas@sun.com>
wrote:

> 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
>



-- 
In ALL things, strive for ><>,
Chris

Mime
View raw message