A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
getIndexInfo , how to get all columns that index applys on them ?
Joined: Jul 14, 2005
Oct 13, 2006 03:05:00
thank you for reading my post.
getIndexInfo is a method of DatabaseMetaData ,
how i can get all column that the index is applied on them ?
for example if there is an index which is created on 3 columns , how i extract them ?
author & internet detective
Joined: May 26, 2003
Oct 13, 2006 06:03:00
Get indexInfo returns a ResultSet object. The schema is listed in the API. For example, COLUMN_NAME is column #9. So you would just loop through the result set.
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I agree. Here's the link:
subject: getIndexInfo , how to get all columns that index applys on them ?
can we get index name ?
Error in retrieving data using java from Column whose name is a reserved word in SQL
How to determine 1:1, 1:M etc. relationships using DatabaseMetaData
A few doubts
Confusion in creating indexes
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015