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

Question

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 !

Answer 1

Try this :::

Show create table tableName

Answer 2

If you are looking to make a new empty table with the same structure and attributes, you can use:

CREATE TABLE newTable LIKE tableName

create table reference