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

 



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