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?

On 29 Mar 2007 13:15:44 -0700, "dave" <dave8421 (AT) hotmail (DOT) com> wrote:

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

On 29.03.2007 23:31, sybrandb (AT) hccnet (DOT) nl wrote:
Enterprise Manager Database Control will also provide this information
quite easily.

Regards

robert

On Mar 29, 10:15 pm, "dave" <dave8... (AT) hotmail (DOT) com> wrote:
TOAD is an easy and powerful tool for managing databases like Oracle,
from v7.x to 10g : browse all the tables per user, display the index,
constraints (primary and foreign keys), triggers, tablespaces, opened
sessions, etc...
You can get a free version here : http://www.quest.com/toad_for_oracle/

--
David

On Mar 29, 1:15 pm, "dave" <dave8... (AT) hotmail (DOT) com> wrote:
Oracle also offers a free tool called "oracle sql developer", which is
available at http://www.oracle.com/technology/index.html.

Rui