From: "Ralf Müller" <r_mueller@...>
Date: 2004-08-06T22:59:47+09:00
Subject: Re: a bit [OT]: table definition with rubyDBI

Am Freitag, 6. August 2004 12:19 schrieb Michael Neumann:
> Ralf M�ller wrote:
> > Hi,
> >
> > I'm very happy with rubyDBI (thanks michael). Especially 
> > DBI::Utils::XMLFormatter.table is great. What i'm looking for is a
> > XMLFormatter for the table definition. As a first approach :
> > 	DBI::Utils::XMLFormatter.table(dbh.select_all("show fields from
> > counter")) seems ok to me.
> > But where are the FOREIGN KEY  definitions?
> > How can i get them out of the database without doing "show create table
> > <tablename>"? Is there a special DBI command or a special MySQL command?
>
> We have the method column_info, but this does not include whether a
> column is a foreign-key or not (only primary, indexed, nullable etc.).
>
> It's probably very database-dependent to get these informations. If you
> find out how to do this in Mysql (or other DBs), please let me know. I
> guess in Postgres it would be a simple select to some internal tables.
>
> Regards,
>
>    Michael

Hi Michael,

i posted my question to mysql@lists.mysql.com and  the only answers are:
SHOW KEYS FROM <dbname>.<tablename>
and:
show table status from <tablename>

cheers
ralf