Way to re-create the table

Hi,
Within Workbench of Mysql, what is the way to get table definition, like to get the relevant script to re-create the whole table?
LVL 12
HuaMin ChenProblem resolverAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Julian HansenCommented:
Yes you can export the table schema like so

1. From Workbench main menu select Server => Data Export
2. From the dialog that comes up select the database on the left and then the tables you want to export on the right
3. Select the export to self contained file and browse to where you want the file saved
4. Check the box that says skip table data (no-data)
5. Click start export

Schema is exported to the specified file
HuaMin ChenProblem resolverAuthor Commented:
I will check this via Workbench and update to this thread. Thanks a lot
Guy Hengel [angelIII / a3]Billing EngineerCommented:
my comment from the other question

using SHOW CREATE TABLE tablename:
https://dev.mysql.com/doc/refman/5.0/en/show-create-table.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Julian HansenCommented:
Guy's comment is generic and will work across all MySQL query tools. The comment I posted was the process on how to export Schema directly from Workbench - which is how I interpreted the question.

Maybe the asker can clarify what the use requirement is so we can determine which is the best suited to the requirement.
Julian HansenCommented:
Can you please give us an indication of why you gave a B grade?

Please see this article on grading guidelines
http://support.experts-exchange.com/customer/portal/articles/481419

I am finding it difficult to understand with the two answers given what more information you could need?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.