Is there any way to generate DDL SQL statements from database?

Question

Given already created SQL databases, is there any way to generate the DDL SQL statements to recreate the database?

user1936123 · Accepted Answer · 2013-03-07T09:51:41.003

9

Given that you have tagged phpMyAdmin, just use the export feature for the whole database. You will be given the option to choose a format, and SQL is one of the options.

mysqldump will do the same thing, with many more options.

edited Mar 07 '13 at 09:51

answered Mar 07 '13 at 08:49

user1936123

241

score 7 · Answer 2 · edited Mar 13 '18 at 11:39

7

The statement SHOW CREATE TABLE table_name, with table_name being the name of the table you're interested in, will give you the query executed to create the table, on the column Create table, and with SHOW CREATE DATABASE database, you'll have the query to create the database itself.

Combining the two should allow you to get what you want.

edited Mar 13 '18 at 11:39

Haggra

133

answered Mar 07 '13 at 08:38

m4573r

5,701

Is there any way to generate DDL SQL statements from database?

2 Answers2