Re: oracle schema 'navigation'
Date: Fri, 30 Mar 2007 11:34:13 +0200
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.
robert Received on Fri Mar 30 2007 - 11:34:13 CEST