Re: DESCRIBE constraints like 'UNIQUE'

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Fri, 2 Mar 2001 16:25:36 +0100
Message-ID: <97oe1h$78n$1@s1.read.news.oleane.net>

"kupisch" <kupisch_at_do.isst.fhg.de> a écrit dans le message news: 3A9FB61D.948CED43_at_do.isst.fhg.de...
> Hi,
>
> I am looking for a command that shows me information like primary keys,
> unique attributes and the like. The 'describe' command isn't able to do
> that (at least on the version 7.2.2.3.0 server I work with). Is there
> any other possibility to get this information?
>
> Thanks.
>

Look at the user_constraints/dba_constraints views with constraint_type in ('U','P').
For information on constraint columns you have the dba_cons_columns/user_cons_columns views.

--
Have a nice day
Michel

Received on Fri Mar 02 2001 - 09:25:36 CST