Skip to content
Advertisement

Generate CREATE statements for all MySql Tables

I want All CREATE statements of MySql Tables in 1 query result.

For example, INFORMATION_SCHEMA contains all table names,comments etc. but where are the CREATE statements are stored in MySql ? can it be retrieved in one query for all tables ?

Currently i am retrieving TABLE ddl as below for 1 table. I have 100’s of tables so i can repeat the same everytime which is time taking process

Advertisement

Answer

How do I use mysqldump to export only the CREATE TABLE commands

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement