MySQL Forums
Forum List  »  General

Re: Creating a Database Schema
Posted by: Jason Collison
Date: January 14, 2005 03:58PM

SHOW TABLES, DESCRIBE, and SHOW INDEX are your friends here. If you're looking for something beyond that, then I don't know. There's probably some 3rd party tool that does in and does DESCRIBEs for you on all tables, but that just saves you a little typing, nothing magical.

This is a database you personally designed? Usually one creates the database from the detailed structure documents, not the other way around. What I do is start out by writing all the CREATE statements in a .sql text file, along with any necessary comments, etc. Then I just copy/paste the commands or simply run the whole .sql file at once. After that, any changes I make are first done in that text document.

Options: ReplyQuote


Subject
Written By
Posted
January 14, 2005 02:42PM
Re: Creating a Database Schema
January 14, 2005 03:58PM
January 14, 2005 04:11PM
January 15, 2005 11:28AM


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.