Dear Ben,
> i have been using the following sql to try and get foreign keys
> working, the table creation works fine but when i try and delete data
> from the parent table it deletes as would normally happen in mysql,
> also the desired results do not happen if i use RESTRICT.
> is this a problem
> 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 s
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