Get create table Query from existing table in phpMyAdmin

You can get the create table query script of an existing table in phpMyAdmin using SHOW CREATE TABLE <table_name>. This Query will give the create query statement of the specified table.

Answers 1
  • Get create table script from existing table in phpMyAdmin

    SHOW CREATE TABLE employee;


    This Query will display the create table script in phpMyAdmin.

    NOTE: If the create script is not fully visible then click on the 'Options' link (which you can see in the image above the create script) and after that Select 'Full Texts' and now click on 'Go' to view full create table script.

  • Back to code snippet queries related sql