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
--
Regards,
Frank van Bortel
Received on Tue Mar 01 2005 - 04:42:39 CST
