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?
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
Run SHOW CREATE TABLE <table name> query.