Re: in which sys-view are unique-constraints

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

USER_CONS_COLUMNS
ALL_CONS_COLUMNS
DBA_CONS_COLUMNS

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)