Re: any sql statement to list child tables?

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: 1998/09/18
Message-ID: <36028000.4C329FC7_at_psi.de>#1/1

Our Oracle tool Hora 3 shows all child and all parant tables in a tree view. You find a free 30 days trial version at http:\\www.keeptool.com

regards Jan Dieckmann
KeepTool GbR

Thenardier_at_POBoxes.com wrote:

> is there any sql statement which can list all the child tables and
> their keys and foriegn keys? ... cos i'm tired of consulting the
> 3-inch technical references anymore! :P
>
> thanx in advance!
>
> rgds,
> thenard
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Sep 18 1998 - 00:00:00 CEST

This message: [ Message body ]
Next message: johnvue_at_gte.net: "Re: how can I drop a column from a table??? Hurry up, please"
Previous message: Alan Knight: "Re: Smalltalk and Oracle"
In reply to: Thenardier_at_POBoxes.com: "any sql statement to list child tables?"
In reply to Patrick Flahan: "Re: more problems with listing pks and fks"
Next in thread: johnvue_at_gte.net: "Re: how can I drop a column from a table??? Hurry up, please"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message