Re: in which sys-view are unique-constraints

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 07 Mar 2005 08:38:37 -0600
Message-ID: <1110205981.ab0deb52088cd674abe192c0e33e9547@teranews>

Frank van Bortel <fvanbortel_at_netscape.net> wrote:

>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".
>>
>> Thank you
>> Sincerely
>> Lore
>>
>>
>P - primary key (and therefore, NOT NULL, and UNIQUE)
>C - check (NOT NULL would be an example)
>R - Relational (Foreign keys)
>
>Of course, all documented

A column could also be forced to be unique if a UNIQUE INDEX was built on it - Not technically a Constraint so not in the all_constraints listing- so you need to check all_indexes and all_ind_columns. Received on Mon Mar 07 2005 - 08:38:37 CST