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