Which version of MySQL? Since version 4.1, there's all you need in the "INFORMATION_SCHEMA" database, in the "TABLES" table. But because of some bug in 4.1, query against that database sometimes caused the server to crash. I'd recommend that method only for 5.x and upwards.

-----------------
Benoit St-Jean
Yahoo! Messenger: bstjean
Blog: lamneth.wordpress.com
A standpoint is an intellectual horizon of radius zero.
(Albert Einstein)

From: "Schwab,Wilhelm K" <bschwab@anest.ufl.edu>
To: "Pharo-project@lists.gforge.inria.fr" <Pharo-project@lists.gforge.inria.fr>
Sent: Tuesday, September 1, 2009 6:58:49 AM
Subject: Re: [Pharo-project] ODBC: table names and column names/types?

Primarily MySQL running on Windows (Linux as soon as reasonable to do so) accessed from both Windows and Linux. There will also be the occaisional .mdb file.

From: pharo-project-bounces@lists.gforge.inria.fr [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Mariano Martinez Peck
Sent: Tuesday, September 01, 2009 3:18 AM
To: Pharo-project@lists.gforge.inria.fr
Subject: Re: [Pharo-project] ODBC: table names and column names/types?

On Mon, Aug 31, 2009 at 10:00 PM, Schwab,Wilhelm K <bschwab@anest.ufl.edu> wrote:

I looked through it in MC, but did not see anything obvious. Even then, I doubt it is a workable choice for me because regardles of what X and - mean in their doumention, one of the DBMS/OS pairs I need is not supported.

Hi Bill! Which is the combination of your RDBMS / OS ?

Regards from the ESUG :)

Mariano

-----Original Message-----
From: pharo-project-bounces@lists.gforge.inria.fr [mailto:pharo-project-bounces@lists.gforge.inria.fr] On Behalf Of Esteban A. Maringolo
Sent: Monday, August 31, 2009 6:38 PM
To: Pharo-project@lists.gforge.inria.fr
Subject: Re: [Pharo-project] ODBC: table names and column names/types?

Hello Bill,

2009/8/31 Schwab,Wilhelm K <bschwab@anest.ufl.edu>:
> Hello all,
>
> Is there anything available for Pharo that gives schema information about a database?

Doesn't SqueakDBX do that?

Regards,

Esteban A. Maringolo

_______________________________________________
Pharo-project mailing list
Pharo-project@lists.gforge.inria.fr
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project

_______________________________________________
Pharo-project mailing list
Pharo-project@lists.gforge.inria.fr
http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project