phpMyAdmin and SHOW CREATE TABLE

Question

Is there a shortcut in phpMyAdmin to SHOW CREATE TABLE for a table (i.e. a button I can click to get the full query, not the truncated one)?

Also, can I query multiple SHOW CREATE TABLEs simultaneously in phpMyAdmin? If I separate them, only the last one appears.

Answer 1

It sounds like what you want is all/part of the result of the 'export' tab.

If you tell it to export in sql, it gives you the table creation and popluation code (for all tables in the database)