Re: Fw: command to get all table schema in a particular database
"Daniel da Veiga" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
On 5/30/06, Jorge Bastos <[email protected]> wrote: > 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? > > You can dump the database structure including all tables using mysqldump. I couldn't think of a command to do that usign SQL querie simply because the result would not be quite a row/col combination. But hey, that's just me... -- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------ -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]