Re: How can I see the schema of my database?
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
Subject
Written By
Posted
Re: How can I see the schema of my database?
August 17, 2009 03:18PM
September 09, 2009 11:29PM
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.