How to view the Create Table SQL command after a table has been created in mySQL phpMyAdmin

Question

When you create a mySQL table using the GUI in phpAdmin there is an option to preview the SQL create table command.

Once you have created a table, made adjustments and finalised the structure, is it possible to review the SQL create command for the current version of the table?

Answer

SHOW CREATE TABLE

Shows the CREATE TABLE statement that creates the named table. To use this statement, you must have some privilege for the table. This statement also works with views.

Accepted Answer

SHOW CREATE TABLEShows the CREATE TABLE statement that creates the named table. To use this statement, you must have some privilege for the table. This statement also works with views.

Advertisement

Answer