| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: DESCRIBE the entire database
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
 |
 |