Script for generating ddl's

Hello,

Is there a script out there that can read the table schemas in a database and generate the ddl statements (create table ...)??

Thanks.

Check out mysqldump (included in your mysql distribution). It dumps a db into a text file with the table create statements and inserts to recreate a table. Check mysqldump help to see if you can have it only dump the table create statements (I think you can) if not, it shouldn't be too big of a hassle to strip out the inserts.