mysqlphpmyadmin

How to generate a create table script for an existing table in phpmyadmin?

How can I generate a create table script for an existing table in phpmyadmin?

Solution

  • Use one of the following queries in sql tab:

    SHOW CREATE TABLE tablename;
SHOW CREATE TABLE database.tablename;

    To view full query There is this Hyperlink named +Options left above, There select Full Texts