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

[tatskie]

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
> 
> 
> -- 
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:   
>
http://lists.mysql.com/win32?unsub=1
> 


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