Re: Creating a Database Schema
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.
Subject
Written By
Posted
Re: Creating a Database Schema
January 14, 2005 03:58PM
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.