List:MySQL on Win32« Previous MessageNext Message »
From:Ilavajuthy Palanisamy Date:May 30 2006 8:37pm
Subject:RE: Fw: command to get all table schema in a particular database
View as plain text  
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

Thread
Fw: command to get all table schema in a particular databaseJorge Bastos30 May
  • Re: Fw: command to get all table schema in a particular databaseDaniel da Veiga30 May
RE: Fw: command to get all table schema in a particular databaseIlavajuthy Palanisamy30 May