Vikram A wrote:
> I would like to export my table structure from MYSQL from a particular db. Is there
> any tool for doing this?
There are several ways to get "structure" information from within MySQL:
the SHOW COLUMNS... command
the SHOW INDEXES... command
the SHOW CREATE TABLE... command
you can also write queries against the tables in the INFORMATION_SCHEMA
You can also use an external utility such as mysqldump. Use the
--no-data option to get just a dump of your table definitions. If you
also want to see triggers and events and stored procedures, you also
need to use the --triggers, --events, and --procedure options, too.
Details are in the fine manual:
I guess the final answer depends on which information are you looking
for and in what format you want to see it. Got any details you want to
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN