Fw: command to get all table schema in a particular database

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"
To:
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?



Ila.






--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Fw: command to get all table schema in a particular database

On 5/30/06, Jorge Bastos 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"
> To:
> 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=gcdmw-win32@m.gmane.org

RE: Fw: command to get all table schema in a particular database

I found the way using mysqldump with option -d.
Thanks a lot for the help.

Ila.


-----Original Message-----
From: Daniel da Veiga [mailto:danieldaveiga@gmail.com]=20
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 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"
> To:
> 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...

--=20
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------

--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=3Dipalanisamy@consentry.c om


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org