Re: oracle schema 'navigation'

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 30 Mar 2007 11:34:13 +0200
Message-ID: <5743s3F2a9vg9U1_at_mid.individual.net>


On 29.03.2007 23:31, sybrandb_at_hccnet.nl wrote:
> On 29 Mar 2007 13:15:44 -0700, "dave" <dave8421_at_hotmail.com> wrote:
>

>> I'm quite new to using databases, and have working knowledge of SQL.
>>
>> Are there any GUI/visual tools available that would quickly show me
>> what foreign key / primary keys are defined on tables?

>
> you don't need a GUI
>
> set long 1000000
> select dbms_meta_data.get_ddl('TABLE',<tablename>,<schema>) from dual;
>
> and you are there.
>
> You are aware of Sql Developer, from Oracle?
> Can be downloaded from http://otn.oracle.com for free.

Enterprise Manager Database Control will also provide this information quite easily.

Regards

        robert Received on Fri Mar 30 2007 - 11:34:13 CEST

Original text of this message