Re: Extracting foreign key info via ODBC (via JDBC)

2002-12-20 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan Hodgkinson wrote: Mark Matthews wrote: [snip] First, you need to use InnoDB tables to be able to extract foreign key information. Ah.. thank you. I had though that native tables in the newer MySQL version, stored and we able re-display, the

Re: Extracting foreign key info via ODBC (via JDBC)

2002-12-20 Thread Alan Hodgkinson
> Mark Matthews wrote: > > > Alan Hodgkinson wrote: > > > > I would like to extract the meta data describing foreign key > > relationships using ODBC (actually in Java using JDBC). > > > > My current version of mySQl 3.23.49 does not seem to support > > it. That is the methods DatabaseMetaData.get

Re: Extracting foreign key info via ODBC (via JDBC)

2002-12-20 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan Hodgkinson wrote: Dear All, I would like to extract the meta data describing foreign key relationships using ODBC (actually in Java using JDBC). My current version of mySQl 3.23.49 does not seem to support it. That is the methods DatabaseMetaD

Extracting foreign key info via ODBC (via JDBC)

2002-12-20 Thread Alan Hodgkinson
Dear All, I would like to extract the meta data describing foreign key relationships using ODBC (actually in Java using JDBC). My current version of mySQl 3.23.49 does not seem to support it. That is the methods DatabaseMetaData.getImportedKeys(...) and DatabaseMetaData.getExportedKeys(..) retu