RE: how to generate a summary of structures of all tables in a da tabase

[jbonnett]

mysqldump will generate SQL statements describing your database and has
options to get almost as much or as little as what you need. There are also
various SHOW commands which will give you similar info

e.g.
SHOW TABLES FROM <dbname>
SHOW FIELDS FROM <tablename>
SHOW KEYS FROM <tablename>

mysqldump is probably easiest if you want everything but it depends what you
want to do with the output.

The SHOW commands can produce recordsets you can further process. mysqldump
writes SQL.

John Bonnett

-----Original Message-----
From: tatskie [mailto:melchorsy@stripped]
Sent: Tuesday, 26 August 2003 10:59 AM
To: win32mysql
Subject: how to generate a summary of structures of all tables in a
database


is there an existing script or a mysql command that
would describe structure of all tables of particular
database? 

tanx

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com