Re: How do I generate DDL for MySQL database

[Ed Carp]

>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?