Home / Database Structure / Tables / Question No: 50

I want to get copy of table structure only of one of the table from my database. Is there a way to get copy of the table structure in the MySQL. Any idea pls?

Use the SHOW CREATE TABLE statement as follow. Run this in any MySQL client tool like phpMyAdmin etc. This may give you the desired result:

SHOW CREATE TABLE [table_name];