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

Question

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

Answer 1

Use the following query in sql tab:

SHOW CREATE TABLE tablename

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