Re: how to generate a summary of structures of all tables in a database

[Matt W]

----- Original Message -----
From: "tatskie" <melchorsy@stripped>
To: "win32mysql" <win32@stripped>
Sent: Monday, August 25, 2003 8:28 PM
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?

Hi,

You mean the CREATE TABLE statements? mysqldump can do that with the -d
or --no-data option. Example:

mysqldump -d database_name

Hope that helps. :-)

Matt