File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes get primar key and foreign keys from table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

get primar key and foreign keys from table

waleed atef abdel elazyz

Joined: Nov 01, 2004
Posts: 13
Dear all,
I have aproblem how to get primary key and foreign key from table

and relation between tables.

please explain code
thanks and best regards
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

Pardon me if I am stating the obvious, but I believe the java.sql.DatabaseMetaData interface is what you need.

Good Luck,
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63870

waleed, please do not post the same question more than once.

forum bartender

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: get primar key and foreign keys from table
jQuery in Action, 3rd edition