Search code examples
mysqlcreate-table

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

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 !

Solution

  • Try this :::

    Show create table tableName