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 foreign keys Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "foreign keys" Watch "foreign keys" New topic

foreign keys

shankar vembu
Ranch Hand

Joined: May 10, 2001
Posts: 309
I am using DatabaseMetaData.getImportedKeys() to get the foreign keys of a table. I am using sybase and the jdbc driver provided by it. My problem is this method is not returning the foreign keys for some tables. But it is working fine if I change the driver to odbc driver and use the jdbc-odbc bridge.What could be the reason for these differences? I think this is the best way to get the foreign keys. Can anyone help me out of this??
Thanx in advance,

I agree. Here's the link:
subject: foreign keys
It's not a secret anymore!