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

How To See SQL Code in phpmyadmin SQL Table

I am trying to see the manual SQL code for a table I created using the graphical user interface. Is there a way to do this and if so how?

Tags:

2

Answers


  1. 0

    use

    SHOW CREATE TABLE tablename

    see manual

    Login or Signup to reply.
  2. 0

    nbk is correct that you would use the SHOW CREATE TABLE command, which is also implemented graphically in phpMyAdmin. From the database structure page (where you see a list of tables), click to select the checkbox for any tables you wish to see the syntax for and the use the "With selected:" dropdown menu on the page to pick "Show create".

    It does the same thing, but using the phpMyAdmin interface.

    "With selected:" dropdown on the table page

    "With selected:" dropdown

    Output of "Show create"

    "Show create" output

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

Back To Top
Search