converting 'describe' into 'create table' in MySQL?

create-table, mysql

Solution

Try this :::

Show create table tableName

Problem

Can we get a 'create table' command from description (describe )? I have a table whose description I can get from "DESC TableName". I wish to know if I can get how that table was created (so that I can use the same command for something else)?. I can get sql-dump but I want to know if there is another way. Thanks in advance !

Original source