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

```
show create table row_format;

```