Re: oracle schema 'navigation'
Date: Thu, 29 Mar 2007 23:31:43 +0200
[Quoted] 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
[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 http://otn.oracle.com for free.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Mar 29 2007 - 23:31:43 CEST