The easiest route is to use mysqldump with the --no-data option. it will dump the full schema info including feign keys, etc.
-- michael dykman On Wed, 2005-02-02 at 13:31, Dan Stromberg wrote: > I have a system with set of web pages that use PHP and a MySQL database. > > Apparently the old webmaster has disappeared, and a new webmaster has > been hired. She needs to know the schema of the database. > > So my question is: Is there a way of querying MySQL not for values of > fields, but rather for the schema of the database? > > Thanks! -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
