From: Jorge Bastos
Date: May 30 2006 5:27pm
Subject: Fw: command to get all table schema in a particular database
List-Archive: http://lists.mysql.com/win32/18309
Message-Id: <00cc01c6840e$4db11fa0$0301a8c0@hercules.decimalint.pt>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

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?

 

Ila.