How to know the relations ???

K

kahriboo

I use JDBC/ODBC with java to communicate with a ACCESS2000 DB.

I want to know the list of foreign keys :

I tried :

===> Select * from MSysRelationships ;
I don't have the privileges to read this table here (but in msaccess i
can)

===> DatabaseMetaData dbmd = connexion.getMetaData() ;
===> rs = dbmd.getExportedKeys(null, null, tableName) ;
The current driver doesn't have the capacity to use this function

So is there a way to know the list of the foreign keys ??

Is there a way too to have the list ok the primary keys of a table
(DatabaseMetaData.getPrimaryKeys don't seems to work too...) ?

Thanks
kahriboo
 
Top