Re: Query on Structure of Database

From: Jorge <cafelito_at_---NO---SPAM---yahoo.com>
Date: Wed, 21 Jul 1999 09:49:29 +0100
Message-ID: <7n3ucj$c0a$1@diana.bcn.ttd.net>

>Are there any SQL commands (or other ways) to get information on the
>structure of a database?

Take a look to these tables:

    USER_TABLES   (or ALL_TABLES)
    USER_INDEXES (or ALL_INDEXES)
    USER_CONSTRAINTS (or ALL_CONSTRAINTS)

>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", ...

select table_name from user_tables where tablespace_name='xxxxx'

bye

Jorge Received on Wed Jul 21 1999 - 03:49:29 CDT