------_=_NextPart_001_01C6840E.0201528C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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.




------_=_NextPart_001_01C6840E.0201528C--

I think there are options on mysqldump that will let you dump just the
database structure and no data. This will give you a bit more than just
create table statements but will certainly give you all the tables.

John B.

-----Original Message-----
From: Ilavajuthy Palanisamy [mailto:ipalanisamy [at] consentry.com]
Sent: Wednesday, 31 May 2006 2:55 AM
To: win32 [at] lists.mysql.com
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=3Dgcdmw-win32 [at] m.gmane.org