I found the way using mysqldump with option -d.
Thanks a lot for the help.
Ila.
-----Original Message-----
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
database
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
>
>
> Hi,
>
>
>
> 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,
table2,
> .. table10.
>
> Instead of doing describe or show create table on individual tables,
is
> 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-----
Version: 3.1
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
To unsubscribe:
http://lists.mysql.com/win32?unsub=1
