can we get index name ?

[Alvin chew]

hi, good day, can someone please guide how to get the existing index name from db ? thank you !

[Senthil B Kumar]

you can execute the query..

SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OBJECT_TYPE='INDEX'

and traverse through the result set to get the name of indexes available in the database.

[Alvin chew]

thanks for reply,kolkata prince ..but i confuse on your sample query

let say i use following query to set index

alter table mytable add index myindex (state,country);

how would the query for getting index would be ? thank you again for your time

[Adeel Ansari]

see the description of USER_INDEXES. it might be helpful.

edited:
assuming that you are using ORACLE.
[ December 17, 2004: Message edited by: Adeel Ansari ]

[Alvin chew]

thanks, adeel ..but i running mySQL
[ December 17, 2004: Message edited by: Alvin chew ]

[Adeel Ansari]

but it should have some statistics table and data dictionary views. look for some relevent object. couldn't say more.

[Alvin chew]

any other friend can help

[Alvin chew]

settled with getIndexInfo() ..thank you

[Jeanne Boyarsky]

"kolkata prince",
We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks,
Jeanne
Forum Bartender