Re: DESCRIBE the entire database

[Quoted] [Quoted] DBArtisan from Embarcadero Technologies is good for describing an entire database.

malcolm

[Quoted] 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_at_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 CEST