Any examples of using DatabaseMetaData?

Thread view:

moop - 19 Dec 2005 09:25 GMT

Hi,
I have a glimpse on koders.com for a while but it is difficult to get a
comprehensive understanding of using various methods of the class, for
instance, how can I obtain primary keys of a given table? How to find
related columns among different tables?

Reply to this Message

Robert Klemme - 19 Dec 2005 10:58 GMT

moopT wrote:

> Hi,
> I have a glimpse on koders.com for a while but it is difficult to get
> a comprehensive understanding of using various methods of the class,
> for instance, how can I obtain primary keys of a given table? How to
> find related columns among different tables?

The JavaDocs are quite comprehensible, see

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html

And especially:

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html#getPrimar
yKeys(java.lang.String,%20java.lang.String,%20java.lang.String)

Kind regards

robert

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...