Re: enquiring

Yes, use DatabaseMetaData. You can obtain it from Connection object:

Connection con;
...
DatabaseMetaData mtd = con.getMetaData();

And then use methods like getPrimaryKeys(...), getCrossReeference(...), getExportedKeys(...), getImportedkeys(...) etc. See Java API.

Hoanui

--- On Tue 05/14, ganaraj k wrote:
> is there any JDBC-API for finding the primary key & foreign key of
> a table ?
> _________________________________________________________
> Click below to visit monsterindia.com and review jobs in India or
> Abroad
> http://monsterindia.rediff.com/jobs
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>

------------------------------------------------
Join Excite! - http://www.excite.com
The most personalized portal on the Web!