Re: Query on Structure of Database

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 21 Jul 1999 21:24:04 +0800
Message-ID: <3795C9F4.2B3D@yahoo.com>

Raoul wrote:
>
> Hello everybody
>
> Are there any SQL commands (or other ways) to get information on the
> structure of a database?
>
> I would like to get information on things like "which tables are within
> a certain tablespace", "what constraints do exist for a field within a
> table", ...
>
> Probably something pretty simple, but I just can't find any starting
> point to search for all this. Any little hint would be welcome.
>
> Thanks a lot
>
> Raoul-Thomas Herborg

cf: Server Reference manual

which will contain the entire database dictionary...

for starters,

dba_tables
dba_indexes
dba_segments
dba_objects
dba_tablespaces

etc etc etc

(select * from dba_views where view_name like 'DBA%') --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 21 1999 - 08:24:04 CDT