Re: DESCRIBE the entire database

Try SQL Navigator from Quest Software for generate and development.

Reverse engineer into Logic Works ERwin/ERX....Forward engineer to generate any/all of the database with/without your modifications. HTH
Dave Fowler

Malcolm Stevens wrote in message <6ruhgv$p04$1_at_hermes.is.co.za>...
>DBArtisan from Embarcadero Technologies is good for describing an
 entire
>database.
>
>malcolm
>
>Joel R. Kallman wrote in message
><35e8a4e1.3136099_at_newshost.us.oracle.com>...
>>On Mon, 24 Aug 1998 16:47:58 GMT, sysdev_at_adpsystems.mb.ca wrote:
>>
>>>Hello,
>>>
>>>When I studied databases in university,
>>>we used Sybase. There was a command in Sybase
>>>that would describe the entire database; show
>>>all the tables, their field structure, primary
>>>keys, foreign keys, and so on.
>>>
>>>Questions:
>>>
>>>What is this command in Sybase?
>>>
>>>Is there an equivilent command in Oracle?
>>>With Oracle's DESCRIBE,
>>>I can only describe tables and views.
>>>
>>
>>There is an *outstanding* book that has many SQL scripts for Oracle.
>>One of these is to generate the DDL for your entire database. This
>>book, from O'Reilly & Associates, is at:
>>
>>
>>http://www.amazon.com/exec/obidos/ASIN/156592438X/002-4176536-4756264
>>
>>>Regards,
>>>
>>>Rodger
>>>
>>>
>>>P.S. -
>>>My ISP is really bad with newsgroups.
>>>They post late, and delete early. Emails to:
>>>sysdev_at_adpsystems.mb.ca
>>>are greatly appreciated.
>>>
>>>-----== Posted via Deja News, The Leader in Internet Discussion
 ==-----
>>>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member
 Forum
>>
>>BTW, the previous posting that included the advice "sp_help" won't
>>work for Oracle. :)
>>Thanks!
>>
>>Joel
>>
>>Joel R. Kallman
>>Oracle Government, Education, & Health
>>Columbus, OH http://govt.us.oracle.com
>>jkallman@us.oracle.com http://www.oracle.com
>>
>>----
>>The statements and opinions expressed here are my own
>>and do not necessarily represent those of Oracle Corporation.
>
>
Received on Tue Aug 25 1998 - 00:00:00 CDT