How to see table definition statements in MySQL

 

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.

Please feel free to use the comments form below if you have any questions or need more explanation on anything.

Tags

mysql, database, tips, sql, create-table,

Popular Searches

php, linux, mysql, ubuntu, mysql mysql, tools, install mysql, gearman, source code, java

more>>

Comments (write a comment):

0 comments so far. Be the first one to leave a comment on this article.

 

Comment
 

 
| Members | Support Us | Using this site means you accept its terms | Contact Us | Site Map |