Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Show CREATE TABLE Statements of Existing Tables

By: FYIcenter.com

(Continued from previous topic...)

How To See the CREATE TABLE Statement of an Existing Table?

If you want to know how an existing table was created, you can use the "SHOW CREATE TABLE" command to get a copy of the "CREATE TABLE" statement back on an existing table. The following tutorial script shows you a good example:

mysql> SHOW CREATE TABLE tip;

+-------+-------------------------------
| Table | Create Table
+-------+-------------------------------
| tip   | CREATE TABLE `tip` (
  `id` int(11) NOT NULL,
  `subject` varchar(80) NOT NULL,
  `description` varchar(256) NOT NULL,
  `create_date` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+-------------------------------
1 row in set (0.38 sec)

Comparing with the original "CREATE TABLE" statement used in the previous tutorial, the output tells you that:

  • INTEGER data type was replaced by "int(11)".
  • Default database engine "MyISAM" was used for the table.
  • Default character set "latin1" was used for the table.

(Continued on next topic...)

  1. What Are DDL Statements?
  2. How To Create a New Table?
  3. What Happens If You No CREATE Privilege in a Database?
  4. How To Get a List of All Tables in a Database?
  5. How To Get a List of Columns in an Existing Table?
  6. How To See the CREATE TABLE Statement of an Existing Table?
  7. How To Create a New Table by Selecting Rows from Another Table?
  8. How To Add a New Column to an Existing Table?
  9. How To Delete an Existing Column in a Table?
  10. How To Rename an Existing Column in a Table?
  11. How To Rename an Existing Table?
  12. How To Drop an Existing Table?
  13. How To Create an Index for a Given Table?
  14. How To Get a List of Indexes of a Given Table?
  15. How To Drop an Existing Index?
  16. How To Create a New View?
  17. How To Drop an Existing View?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...