phpmyadmin Question posted in
The official documentation can be found here.

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

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?

Tags:

2

Answers


  1. 0

    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.

    Login or Signup to reply.
  2. 0

    While creating table there is PreviewSQL button:

    enter image description here

    You can always export table and see its SQL again or SHOW CREATE TABLE.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search