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

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? 

Many thanks
Ralf