Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!o5g2000hsb.googlegroups.com!not-for-mail From: "dmol" Newsgroups: comp.databases.oracle.tools Subject: Re: oracle schema 'navigation' Date: 1 Apr 2007 15:51:31 -0700 Organization: http://groups.google.com Lines: 17 Message-ID: <1175467891.447876.92530@o5g2000hsb.googlegroups.com> References: <1175199344.045657.233160@p77g2000hsh.googlegroups.com> NNTP-Posting-Host: 90.11.59.178 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1175467892 30490 127.0.0.1 (1 Apr 2007 22:51:32 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sun, 1 Apr 2007 22:51:32 +0000 (UTC) In-Reply-To: <1175199344.045657.233160@p77g2000hsh.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: o5g2000hsb.googlegroups.com; posting-host=90.11.59.178; posting-account=TQMj8g0AAABo8i2xBPhBo8VagGTiVMwm Xref: usenetserver.com comp.databases.oracle.tools:180837 X-Received-Date: Sun, 01 Apr 2007 18:51:33 EDT (text.usenetserver.com) On Mar 29, 10:15 pm, "dave" 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? 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