How to see table definition statements in MySQL

Tutorials > Database Management Systems > MySQL > Tips And Tricks > How to see table definition statements in MySQL

Discuss this tutorial here | Search www.geeksww.com for more tutorials here

Use the command described in the tutorial to find complete CREATE TABLE SQLs for MySQL tables.

Execute the command below from any MySQL client.

SHOW CREATE TABLE <table name>;

Replace <table name> with your table name

A much faster and simpler approach of doing the same thing requires MySQL Query Browser. From Query browser, right click on the table name and click on 'Copy CREATE statement to Clipboard' OR Ctrl-C. The CREATE table statement will be copied to your clipboard from where you can paste it wherever you want.

Discuss this tutorial here | Search www.geeksww.com for more tutorials here

Support Geeks Worldwide:

Link to us:

You can support us by putting a link to our website on your blog or website (code is below).

<a href="http://www.geeksww.com/">
Geeks Worldwide - Tutorials about Software Installation,
Configuration, Administration, Monitoring, Tools, Tips &
Tricks
</a>

OR a simple one.

<a href="http://www.geeksww.com/">
Geeks Worldwide - IT related Tutorials
</a>

Feedbacks:

We appreciate feedbacks and suggestions about our tutorials and Geeks Worldwide from readers. Please contact us using the form here and let us know what you think about the tutorial and the website in general.

Bookmark Us:

We are working on new features for the website, please keep visiting or bookmark us using your favourite bookmarking service.

Subscribe to RSS:

You can subscribe to our RSS feed here.