YOUR WEBSITE

The  SHOW CREATE TABLE  can be used to view the exact statement that was used to create an existing table. This can be helpful in understanding the structure of a table.  It can also be used as a basis for the syntax to create a new table.  For example to show  CREATE TABLE command to create the city table use the following statement; mysql> SHOW CREATE TABLE CountryLanguage\G *************************** 1. row ***************************        Table: CountryLanguage                 Create Table: CREATE TABLE `countrylanguage` (               ` Country` char(3) NOT NULL,                `Language` char(30) NOT NULL,                `IsOfficial` enum('True','False') NOT NULL DEFA...