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

[Tim Endres]

mysqldump -? will show you that there is a -T option for this.

> yes it works but how do we put the result to a txt
> file?
> 
> --- Matt W <mysql_lists@stripped> wrote:
> > ----- 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