Jump to content

Archived

This topic is now archived and is closed to further replies.

bubberz

Generate SQL script for table

Recommended Posts

Is there a way to get the mySQL monitor to generate the SQL script for the creation of a table? I'm kinda looking for the same thing SQL Server does to allow you to preview the SQL script for a table.

 

Thanks!

Share this post


Link to post
Share on other sites

If you have phpmyadmin or any mysql management software, usually there is a way to "dump" a database or a table. That will give you a printout of the actual SQL queries to make the database. Hope that helps

 

Chris

Share this post


Link to post
Share on other sites

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]SHOW CREATE TABLE tablename [!--sql2--][/div][!--sql3--]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.