From: Ed Carp
Date: March 31 1999 4:37am
Subject: Re: How do I generate DDL for MySQL database
List-Archive: http://lists.mysql.com/mysql/1222
Message-Id: <00e501be7b30$b16cd960$75c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>Data Definition Language -- SQL text that will create the tables and
indices
>for an existing database.
>
>I'm looking for a script that will look at an existing database and
generate
>this from the "show tables", "show columns" and "show indexes" for that
>database.


I'm not sure I understand what you want - mysqldump does a great job.  Isn't
that what you're looking for?