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>
Sent: Tuesday, May 30, 2006 6:24 PM
Subject: command to get all table schema in a particular database
Is there any command available to get all the table schema in a
If I have database called TESTDB and say it has tables, table1, table2,
Instead of doing describe or show create table on individual tables, is
there any command to get all the table schema in go?