RE: command to get all table schema in a particular database
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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:[email protected]] Sent: Wednesday, 31 May 2006 2:55 AM To: [email protected] 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]