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" <[email protected]>
To: <[email protected]>
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/[email protected]