Re: system table for constraints

select owner,constraint_name,constraint_type from dba_constraints where owner = "{SCHEMA_NAME}";

Johannes Lebek wrote:
> 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
>
Received on Tue Oct 28 2003 - 13:46:36 CST