Re: oracle schema 'navigation'

From: <>
Date: Thu, 29 Mar 2007 23:31:43 +0200
Message-ID: <>

[Quoted] On 29 Mar 2007 13:15:44 -0700, "dave" <> 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
[Quoted] 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 for free.

Sybrand Bakker
Senior Oracle DBA
Received on Thu Mar 29 2007 - 23:31:43 CEST

Original text of this message