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.

Let me have a look at Derby's documentation for you. Oh there, ████████████████████████████████████████. Isn't that a command for displaying the list of indexes?

Of course, simply doing ███████████ is fine too.

shhh, Kids...

Yeah. I can tell that you didn't look at the documentation by the fact that you claim to know the answer.

The answer is not in the documentation. THE DOCUMENTATION SAYS TO TYPE 'SHOW INDEXES'. I have spent the past several hours scouring the internet for the answer to this problem, fuck you.

this is all it ever fucking says

TABLE_NAME          |COLUMN_NAME         |NON_U&|TYPE|ASC&|CARDINA&|PAGES

LOL U MUST HAS SUM VIRUS BLEEV ME FORMAT UR HARD DISK AN REINSTALL WINDOWS

>>3,4
Then it seems you don't have indices.

Also
2011
Not using Oracle

>>6
ahahahahahaha

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

>>8
Forgot your semicolon.

There's too much /g/ in /prog/ today.

>>10
There's too much cum in your anus today.

>>10
It's /prog/'s Eternal September. I honestly don't even know why I still come here. The only way to salvage this place is to put it back on the original domain, completely de-link and have it disassociate itself from 4chan. Of course that'll never happen, because VacBob stopped giving a shit long ago, and moot is too pigheaded.

>>12
host your own textboard if you don't like /prog/

>>12
I've been here for ages as well and have felt like abandoning this place multiple time. However, I also understand that this is the nature of anonymous message boards and agree with the saying, "Be the change you want to see" and as a result, I haven't posted shit posts here since 2009, and try to contribute constructively whenever possible.

>>13
Apparently, Xarn is working on his own textboard script, and will most likely host it on his site. I think he pretty much holds a monopoly on any real functioning alternative to this place.

>>14
I suppose decline is inevitable, until /prog/ ends up being a text-only /g/. At that point, I'll truly abandon this place, but it seems like there's still a little life, yet. Might as well enjoy it while it lasts.

>>12-15butthurt faggot lithperth

>>14
Wait, so you come here for constructive posts?

The constant stream of shit cracks me up.

>>15
Who would want to post on a textboard moderated by Xarn?

>>18
Who would want to post on a moderated textboard?
ftfy

So suppose you have an empty textboard, make anonymous posts and reply to yourself(disable timestamps for maximum effect). When you get >100kb of drivel and trolling, start subtly advertising it on 4chan and get it indexed by Google.
Wait for visitors to come in and reply to them fast, get them hooked and waiting for more. Repeat for few months and add google ads if you start to get regular traffic.

>>18
That would be a place with high signal/noise ratio and no freedom of speech.

>>21
At this point, I'll take the high signal/noise ratio.