Re: in which sys-view are unique-constraints

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Tue, 01 Mar 2005 11:57:15 GMT
Message-Id: <pan.2005.03.01.12.57.55.465029@gmail.com>

On Tue, 01 Mar 2005 00:18:12 +0100, Lore Leuneog wrote:

> Hello
>
> Does anyone know in which sys view I can find which columns have unique
> constraints?
> Because all_constraints has only constraint_type which is P (for primary
> key) and C (for nonnull?) and R (for?) but nothing for "unique".
>

Check again.

From the "Oracle9i Database Reference / Release 2 (9.2)" manual, found at http://docs.oracle.com (Part Number A96536-02), Chapter 2 "Static Data Dictionary Views", section "ALL_CONSTRAINTS", for column "CONSTRAINT_TYPE"

"
CONSTRAINT_TYPE VARCHAR2(1) Type of constraint definition:

C (check constraint on a table)
P (primary key)
U (unique key)
R (referential integrity)
V (with check option, on a view)
O (with read only, on a view) "

FGB Received on Tue Mar 01 2005 - 05:57:15 CST