Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: oracle schema 'navigation'

Re: oracle schema 'navigation'

From: <sybrandb_at_hccnet.nl>
Date: Thu, 29 Mar 2007 23:31:43 +0200
Message-ID: <qubo03dlptvagedu4uqkek2vm6k46d8l4m@4ax.com>


On 29 Mar 2007 13:15:44 -0700, "dave" <dave8421_at_hotmail.com> wrote:

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

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu Mar 29 2007 - 16:31:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US