I found the way using mysqldump with option -d.
Thanks a lot for the help.
From: Daniel da Veiga [mailto:danieldaveiga@stripped]
Sent: Tuesday, May 30, 2006 12:40 PM
To: MySQL Win32 List
Subject: Re: Fw: command to get all table schema in a particular
On 5/30/06, Jorge Bastos <mysql.jorge@stripped> wrote:
> I'm not sure but i think not...
> You'll have to do a loop like:
> show tables from TESTDB;
> ----- Original Message -----
> From: "Ilavajuthy Palanisamy" <ipalanisamy@stripped>
> To: <win32@stripped>
> Sent: Tuesday, May 30, 2006 6:24 PM
> Subject: command to get all table schema in a particular database
> Is there any command available to get all the table schema in a
> particular database?
> For e.g.
> If I have database called TESTDB and say it has tables, table1,
> .. table10.
> Instead of doing describe or show create table on individual tables,
> there any command to get all the table schema in go?
You can dump the database structure including all tables using
mysqldump. I couldn't think of a command to do that usign SQL querie
simply because the result would not be quite a row/col combination.
But hey, that's just me...
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32