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.
Did this tutorial help a little? How about buy me a cup of coffee?
Please feel free to use the comments form below if you have any questions or need more explanation on anything. I do not guarantee a response.
IMPORTANT: You must thoroughy test any instructions on a production-like test environment first before trying anything on production systems. And, make sure it is tested for security, privacy, and safety. See our terms here.
tags cloud
popular searches
free download for mysql database server 5.1.5, bison, gearman, source code, php, install cairo, java, mysql, laptop, install mysql, linux, mysql mysql, mysql initialization, tools, ubuntu
Similar Tutorials:
- How to rename MySQL DB by moving tables
- Install MySQL Server 5.0 and 5.1 from source code
- Not-so-well-known differences between MyISAM and Innodb MySQL server storage engines
- How to find if MySQL supports partitioning or not?
- The server requested authentication method unknown to the client [phpmyadmin]
Tutorials in 'Database Management Systems > MySQL' (more):
- What should be monitored on a busy Database/MysQL server?
- How to speed up a Mysql replica?
- The server requested authentication method unknown to the client [phpmyadmin]
- How to set default values for MySQL JSON columns
- How to delete rows in table when PK is referenced in another table
Comments (write a comment):
0 comments so far. Be the first one to leave a comment on this article.