Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: none

Re: none

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 29 Sep 2001 09:17:13 -0500
Message-ID: <ud749dihw.fsf@verizon.net>


On Fri, 28 Sep 2001, mizhao_at_cisco.com wrote:

> From what system table or view I can find all foreign keys
> including table name and colunm names for both parent and child
> table?

all_cons_columns
all_constraints

-- 
Galen Boyer
I have nightmares about Tinky Winky beating me with his red bag.
Received on Sat Sep 29 2001 - 09:17:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US