How to 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

~ Answered on 2012-07-31 11:27:48