Re: DESCRIBE the entire database
Date: 1998/08/27
Message-ID: <01bdd1d9$8bc20a60$a504fa80_at_mndnet>#1/1
Hi !
Here is the script that you are looking for:
REM
REM Author : Oracleguru REM Date : 01/28/94 REM File Name : describe_tables.sql REM Usage : On sqlplus prompt enter: _at_describe_tables REM Description: Describes Tables and Views in Oracle Database. REM REM To describe objects in a user's Schema REM add the line REM and owner = upper('&1') below REm and on sqlplus prompt enter: REM _at_describe_tables user_id REM It is assumed that you can access that user's objects.REM
set heading off feedback off verify off wrap on pause off prompt
prompt Description of Tables and Views is being sent to prompt file $HOME/rep/describe_tables.lst prompt
prompt Please wait ....
set termout off
spool desc1.sql
prompt spool $HOME/rep/describe_tables.lst prompt set termout off
select 'prompt Description of '||object_type,object_name,
'prompt Owned by '||owner||' ','desc '|| object_name from all_objects
where ( object_type = 'TABLE' or
object_type = 'VIEW' )
order by owner, object_type, object_name
/
prompt prompt
prompt prompt
prompt prompt . ********** END OF REPORT **********
sysdev_at_adpsystems.mb.ca wrote in article
<6rs5fu$4ut$1_at_nnrp1.dejanews.com>...
> 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.
>
> 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
>
Received on Thu Aug 27 1998 - 00:00:00 CEST