MySQL Forums
Forum List  »  MySQL Administrator

Re: How can I see the schema of my database?
Posted by: Paul Svirin
Date: August 17, 2009 03:18PM

Well.

To list all tables in your database you have to run:

SHOW TABLES;

To describe the table (shows the columns information in convenient format):

DESC <table>;

To show create statement for the table run:

SHOW CREATE TABLE <table name>;

And you can get the database schema by running the following in the, say, UNIX commandline:

mysqldump --no-data <database_name>


Hope that helps.

------------------
Starwind Software developer

Options: ReplyQuote


Subject
Written By
Posted
Re: How can I see the schema of my database?
August 17, 2009 03:18PM


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.