Re: constraints and foreign keys

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1996/09/04
Message-ID: <322E42E0.17B_at_cadvision.com>#1/1

maevans wrote:
>
> I've got several referencial constraints attached to tables. How do I
> get the table name and column name of the the constraint for a particular
> table? I'm sure its simple but it eludes me...

I think you'll find that the views DBA_/USER_/ALL_CONSTRAINTS has what you are looking for.

Wayne Linton Received on Wed Sep 04 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Benjamin Taub: "JOB: DATA WAREHOUSE CONSULTANT"
Previous message: Tim Taylor: "Re: constraints and foreign keys"
In reply to maevans: "constraints and foreign keys"
Next in thread: Robin Aylesworth: "Re: constraints and foreign keys"

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

Original text of this message