MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

How to generate the creation schema of all tables in a database?
Posted by: yudong.sun
Date: April 21, 2005 02:24AM

I want to export all table creation schema of a mysql database. What command can do that in a run?

mysqldump exports all data which I don't need.

SHOW CREATE TABLE command can only show the schema of one table.

Then, is there any command able to export the creation script of all tables in a database?

Thanks.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to generate the creation schema of all tables in a database?
15490
yudong.sun
April 21, 2005 02:24AM
Re: How to generate the creation schema of all tables in a database?
7098
Felix Geerinckx
April 21, 2005 04:11AM
Re: Convert mysql script to ansi?
6442
yudong.sun
May 04, 2005 11:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.