Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: system table for constraints
Entering the phrase "Oracle documentation" into google will lead you to the
online searchable documentation at http://tahiti.oracle.com. Working on the
principle that views about system objects are named ALL_<description of what
the view contains> and taking a wild stab at ALL_CONSTRAINTS is an approach
that might bear fruit as well.
-- Niall Litchfield Oracle DBA Audit Commission Uk "Johannes Lebek" <reply-to-newsgroup_at_domain.com> wrote in message news:bnlt3q$g64$1_at_sp15at20.hursley.ibm.com...Received on Tue Oct 28 2003 - 09:26:30 CST
> Hi there,
> I'm looking for a system table that stores information about constraints
> (especially, the SCHEMA name of a UNIQUE constraint).
> Unfortunately, I do not have an Oracle reference at hand.
> Is there someone, who could tell me?
> Thanks,
>
> Johannes
>
![]() |
![]() |