I'm not sure what you are asking, so I will take a guess...

If you want to access the metadata on all tables in db "MY_DB" you can
do something like..

SELECT table_name, table_type, engine FROM INFORMATION_SCHEMA.tables
WHERE table_schema = 'MY_DB' ORDER BY table_type ASC, table_name DESC;

Or you can just use "describe table_name;" to get data on that specific table.

-mike

On 8/19/07, Mario T. Lanza <mlanza / comcast.net> wrote:
> Hi All,
>
> How do I go about getting the "Comments" metadata--the one I type via
> MySQL Administrator, for example--associated with a MySQL column?
>
> I have been able to pull metadata from both ActiveRecord and DBI but
> cannot seem to find this added bit of info.
>
> Thanks.
> Mario T. Lanza
> --
> Posted via http://www.ruby-forum.com/.
>
>


-- 
Michael Steinfeld
Linux Admin/Developer
AIM: mikesteinfeld
GTALK: mikeisgreat / gmail.com