Re: How to view the all relationship between tables if I don't know how many relationships

Home -> Community -> Usenet -> c.d.o.server -> Re: How to view the all relationship between tables if I don't know how many relationships

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Mar 2003 07:40:47 -0800
Message-ID: <2687bb95.0303100740.12eb6080@posting.google.com>

wfalai_at_sinaman.com (Fai) wrote in message news:<91cc15e6.0303100051.39216779_at_posting.google.com>...
> How to view the all relationships between tables if I don't know how
> many relationships?

Fai, the application design may or may not have the relationships defined in Oracle through PK to FK relationships, but might handle some or all of them purly through code.

You can find the FK to PK or UK relationships by looking at dba_constraints. Dba_cons_columns contains the column names involved in constraints.

HTH -- Mark D Powell -- Received on Mon Mar 10 2003 - 09:40:47 CST