NEED INDEX NAMES

I am writing a program in JavaDB. I am using the ij command line thing. I created some indexes and promptly forgot their names. I need to drop these indexes because I need to insert 10 billion rows which, at the rate it's doing it, is going to take several fucking years.

AS FAR AS I CAN TELL THERE NO INFORMATION ANYWHERE ON HOW TO VIEW INDEX NAMES.

tl;dr if someone can tell me how to view index names of a derby/javadb database using ij that would be nice. 'show indexes' is not the right answer.

>>6
It's an embedded java database you shit. I only pasted the first line anyways, there are values under there. My point being that none of those columns say a goddamn thing about what the index name is.

Anyways, I got this shit on my own. Apparently while index names are very clearly not even stored somewhere where anyone can ever see them, there's a thing called 'drop constraint'. And in sys.sysconstraints, which is a table itself that you can query apparently, there are constraint names.

So my stuff works now. Too bad

ALTER TABLE prog DROP CONSTRAINT ignorant_assholes

will always throw an exception.